R12 Using Install Base Web ADI - Run-time error'1004' Method 'VBProject' of object '_Workbook' failed

R12 Using Install Base Web ADI  

In order to know about “How To Use Install Base WebADI Mass Update Feature In Release 12.1.3” please check the metalink DOC ID 1536498.1.

Here we will explain how to resolve the error Run-time error'1004' Method 'VBProject' of object '_Workbook' failed.

After you download the WEB ADI for IB most of the users receives the below error

 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.)

For Excel 2007

Step1: Go to excel and click on office button. Click on Excel Options

Step2: Go To Trust Center Tab. Click on Trust Centre Settings

 

Step3: Go To Macro Settings Tab. Enable Check Box Trust Access to the VBA project object model

Step4: Click on OK

Step4: Restart the machine and open the WebADI

For Excel 2010: You will find the option under the File menu