Web ADI Error While Downloading Excel file :

WebADI Run-time error'1004' Method 'VBProject' of object '_Workbook' failed

 

 

Root Cause of the Error
MS Excel not enabled for trusted access to VBA Project Object Model
How to reproduce the error?
1. Navigate to General Ledger responsibility > Journals > Launch Journal Wizard
2. Select the Layout = 'Functional Actuals Single' and Content = 'None', and hit button 'Create Document'
3. WebADI Excel spreadsheet will be downloaded on your desktop
4. Open the file and error appears
Solution
For MS Excel 2010:
1. Go to File > Options > Trust Center
2. Bit the button 'Trust Center Settings'
3. Click the checkbox 'Trust access to VBA project object model' 
4. Now retry opening the WebADI spreadsheet and the error will not appear.