解决打开WEB ADI的excel文件时出现Run-time error '1004' 的错误

 

解决打开WEB ADI的excel文件时出现Run-time error '1004' 的错误。下面的解决方法来自My support

 

Run-time error '1004' Opening WebADI Spreadsheet to Import Dimension Members [ID 376013.1]
		修改时间 03-MAY-2010     类型 PROBLEM     状态 PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

---

 

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 3-May-2010.

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".  For Excel 2007, you have updated the Internet Explorer Security Settings (Security > Internet > Custom Level...) to set the Scripting option "All status bar updates via script" to "Enable".

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"