WebAdi Links useful Note Id

Webadi Error: Method 'Vbproject' Of Object'_workbook' [ID 406526.1]
Exception Name: Scripting Error Unknown runtime error: 'Sheets' [ID 299769.1]
Download WebADI Document Stuck at "Do not close this window until processing completes" [ID 752760.1]
Web Adi Cannot Create Journal Document In Excel 2007 [ID 1366138.1]
Web Adi With Ms Office 2007 [ID 862046.1]
Attempting To Create Batch using BEE Spreadsheet Interface, Errors: Run-time error '1004': Method 'VBProject' of object '_Workbook' failed [ID 337695.1]
Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator) [ID 417692.1]
Run-time error '1004' Opening WebADI Spreadsheet to Import Dimension Members [ID 376013.1]
Visual Basic Error 1004 in Create Document Using Excel-2003 Viewer with Asset Additions Integrator [ID 317145.1]
Run-time Error '1004' When Attempting To Use Spreadsheet Expenditure Entry [ID 309728.1]

WebAdi Method 'VBProject' of Object'_Workbook' Failed

Symptoms
 When attempting to open the webadi file
the following error occurs.
ERROR
Run-time error '1004':
Method 'VBProject' of Object'_Workbook' Failed
STEPS
The issue can be reproduced at will with the following steps:
1.when click on the "New Impairment" button, the WebADI is successfully launched.
2.Download the WebADI spreadsheet to the desktop.
3.When try to open the file, it prompts with an error:
Run-time error '1004':
Method 'VBProject' of Object'_Workbook' Failed
BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot use functionality wish uses the webadi launch. 
Cause
 The 'Approve Access to Visual Basic Project' has been disabled.
Solution

In the Excel go to Tool->Macro->Security --> trusted source tab.
Enable the 'Approve Access to Visual Basic Project' checkbox
In Excel 2007:
Open Excel 2007.
Click the Office Button (top-left most button in the window)
Click the Excel Options button.
Click Trust Center in the menu on the left.
Click Trust Center Settings in the window on the right.
In the new window that opens click Macros in the menu on the left.
Check the box next to Trust Access to the VBA project object model.
Click OK.
Click OK.
Close all Office applications and try again