Oracle Web ADI : Run-time error ’1004′ Opening WebADI Spreadsheet


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”

 

About these ads

One response to “Oracle Web ADI : Run-time error ’1004′ Opening WebADI Spreadsheet

  1. GOOD! Used!
    Thanks
    Ram Shankar

    Used

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s