Thursday, November 8, 2012

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

No comments: