Problem: When Web ADI launches Microsoft Excel, the output Excel spreadsheet does not run.
Solution: This problem seems to be occurring only in Microsoft Excel 2003. In Excel 2003, Enable Trust VB Projects.
Step 1: After launching Excel 2003, navigate to Tools > Options.
Step 2: Click the Security tab.
Step 3: Click the Macro Security button.
Step 4: Click the Trusted Publishers tab.
Step 5: Ensure that Trust access to Visual Basic project is checked.
Step 6: Click OK to exit the option. Click OK again.
Refer to Metalink Doc ID: Note: 106528.1 (Subject: Application Desktop Integrator – Product Documentation)
Refer to Metalink Doc ID: Note: 376976.1 (Subject: WEB ADI “Run-Time Error ‘50290’ Method ‘Run’ Of Object ‘_application Failed”)
Refer to Metalink Doc ID: Note: 295901.1 (Subject: No Excel File Created When Using Excel 2002; Excel 2002 Does Not Appear In Viewers LOV)
See also http://support.microsoft.com/default.aspx?scid=kb;en-us;282033
0 Comments.