Monday, 18 November 2013

Creating web ADI document fails with error ‘1004: Method VBProject of object _Workbook failed’ on office 2013


Oracle R12 12.1.3
Office 2013





To create document successfully do the following steps

Add the site in trusted sites on explorer (Tools > Internet Options > Security > Sites)


Open excel File > Options > Trust center               





Click on Trust Center settings


Select Disable all macros with notification
Check Trust access to the VBA project object model
Click Ok


Now the document will get created but add in tab will be missing with oracle options
Right Click on the Ribbon area and click customize ribbon


Select Main Tabs from “Choose command from List”
Create a New Tab


Select Macro and select BneCreateOracleMenu and Click Add


Click on the New Tab > BneCreateOracleMenu
This will Display addin with oracle options


Save the file as macro enabled work book.
Use this file for future upload


No comments:

Post a Comment