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
No comments:
Post a Comment