Thursday, November 8, 2012

WebAdi Method 'VBProject' of Object'_Workbook' Failed

 When attempting to open the webadi file
the following error occurs.

Run-time error '1004':

Method 'VBProject' of Object'_Workbook' Failed
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
The issue has the following business impact:
Due to this issue, users cannot use functionality wish uses the webadi launch. 
 The 'Approve Access to Visual Basic Project' has been disabled.

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

1 comment:

lee woo said...

It is impossible to live without failing at something, unless you live so cautiously that you might as well not have lived at all, in which case you have failed by default. See the link below for more info.