Oracle Web ADI Error “Run-time error ’91′”

Oracle Web ADI Error “Run-time error ’91′”

Getting following error message when trying to create Oracle Web ADI Template using MS Excel 2007/2010

=================
Error Message:
=================

Microsoft Visual Basic
Run-time error ’91’:
Object variable or With block variable not set

=================
Environment
=================

Oracle Application: 11.5.10.2
MS Excel 2007 or MS Excel 2010
=============
Description
=============
Microsoft Excel 2007/2010 security setting is perventing to create Web ADI Template.

==========
Solutions
==========

We have two solutions for this.

Solution #1: Safe solution

Open MS Excel 2007/2010 and navigate to File–> Options –> Trust Center

  Click on the “Trunst Center Settings” button

  Go to Trusted Locations, click on the “Add New Location” button
  and add new location where you save your WEB ADI Templates
      For example :C:\Work\Template\

  Click on the “Ok” button and try to create Web ADI Template using “Oracle Web ADI” Responsibility.

Note: Solution #1 will be safe because you are not chaging MS Excel security settings for unwanted program. 

Solution #2: Unsafe solution

Open MS Excel 2007/2010 and navigate to File–> Options –> Trust Center –> Protected View
and Disbale all following setting

  Enable Protected View for files originating from the internet
  Enable Protected View for files located in potentially unsafe location
  Enable Protected View for Outlook attachment
  Enable Data Execution Prevention Mode
 
  Click on the “Ok” button and try to create Web ADI Template using “Oracle Web ADI” Responsibility.

Note: Solution #2 will not be safe because you are disableing MS Excel security settings.