My Oracle Support Banner

Run-time error '1004' Opening WebADI Spreadsheet to Import Dimension Members (Doc ID 376013.1)

Last updated on OCTOBER 22, 2018

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.


In Enterprise Performance Foundation Administrator (FEM), when trying to import dimension members using the "Create from Spreadsheet" button located at "Configuration Rules" > "Dimension" > "Members", the following error occurs when you open WebADI.xls:

Run-time error '1004':

Method 'VBProject' of object '_Workbook' failed

You did select the "Enable Macros" button when opening the spreadsheet.  Additionally, in Excel 2003, if you go to "Tools" > "Macro" > "Security...", the Security Level is "Medium".  For Excel 2007, you have updated the Internet Explorer Security Settings (Security > Internet > Custom Level...) to set the Scripting option "Allow status bar updates via script" to "Enable".


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.