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

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...