How To Use WEB ADI WITHOUT Enabling 'Trust Access To The VBA Project Object Model' In Excel? (Doc ID 2004134.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.2.4 and later
Information in this document applies to any platform.
Reviewed Sept. 28, 2016

Goal

How to use WEBADI WITHOUT enabling 'Trust Access to the VBA project object model' in Excel as documented in <Note: 1077728.1> Microsoft Office Integration with Oracle E-Business Suite 11i and R12


Step 4.1. Microsoft Excel Configuration Requirements for WebADI Integration
To integrate Microsoft Excel with WebADI, make sure the following settings are enabled in Microsoft Excel and Internet Explorer on the users desktop.

Step 4.1.1. Macro Security Settings for Microsoft Excel
Microsoft Excel 2010 and 2013 Users
1.Click ' File' -> 'Options'
2.Click 'Trust Center' link in the 'Excel Options' window.
3.Click 'Trust Center Settings...' button.
4.In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
5.Under 'Macro Settings' check 'Disable all macros with notification'.
6.Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
7.Click 'OK' button to close the 'Trust Center' window.
8.Click 'OK' button to return to the spreadsheet.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms