Tuesday, April 10, 2012

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


ISSUE:

Run-time error '1004':

Method 'VBProject' of Object'_Workbook' Failed
this issue reproduce when downloading the excel sheet via webADI .

SOLUSTION:
In Excel 2003:
go to "Tools" > "Macro" > "Security" and select the "Trusted Sources" tab.  Check the box next to "Trust access to Visual Basic Project".
(Note: The box for "Trust all installed add-ins and templates" should also be checked.)

In Excel 2007, use the following navigation:
  • Click on the Office button in the upper left corner
  • Click on the Excel Options button
  • On the left, click on the Trust Center
  • Click on the Trust Center Settings button
  • On the left, click on Macro Settings
  • Click on "Trust access to the VBA project object model"
Ref: 376013.1
       406526.1     

No comments:

Post a Comment