Runtime Error 1004 Method 'VBProject' of object '_Workbook' failed

Symptoms

In Enterprise Performance Foundation Administrator, 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".

Cause

In the Excel macro security area, Visual Basic Project is not selected as a trusted source.

Solution

In Excel 2003, go to "Tools" > "Macro" > "Security" and select the "Trusted Sources" tab. Check the box next to "Trust access to Visual Basic Project".

(Note: The box for "Trust all installed add-ins and templates" should also be checked.)

In Excel 2007, use the following navigation:

• Click on the Office button in the upper left corner
• Click on the Excel Options button
• On the left, click on the Trust Center
• Click on the Trust Center Settings button
• On the left, click on Macro Settings
• Click on "Trust access to the VBA project object model"

转自：https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=376013.1