Monday, May 10, 2021

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


While opening web ADI below issue may arise.



 Solution

For resolving this issue follows below steps
Step - 1 : Go to excel and click on Office Button. Click on Excel Options




Step - 2: Go to Trust Centre Tab. Click on Trust Centre Settings


Step - 3: Go to Macro Settings Tab. Enable check box Trust Access to the VBA project object model


Step - 4: Click on ok




Step - 5: Click on ok


Step - 6: Restart the Machine and open the web ADI.

 

No comments:

Post a Comment

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...