While downloading Web ADI spreadsheet first time, you may get this error
Run-time error ‘1004’:
Method ‘VBProject’ of object ‘_Workbook’ failed
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”
GOOD! Used!
Thanks
Ram Shankar
Used
LikeLike