error code 1003 - macro

[lin28]

I have just started working with Cognos.
When I try to run a macro in order to export a report to excel document I get the following error message:
Error 103 ERROR exception not handled by program.
I use a basic macro.
Sub Main()
Dim objImpApp As Object
Dim objImpRep As Object
Dim strExcelFileName As String
Set objImpApp = CreateObject("CognosImpromptu.Application")
Set objImpRep = objImpApp.ActiveDocument
strExcelFileName = Left$(objImpRep.FullName, Len _
(objImpRep.FullName) - 4)
objImpRep.ExportExcel strExcelFileName & ".xls"
Set objImpRep = Nothing
Set objImpApp = Nothing
End Sub

What do you think is the cause?

 

[griffindm]

Not sure why you are seeing this. You code runs fine for me.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[lin28]

I use Impromptu administrastor 7.0.809.0.
What version do you use?

 

[fuhbar]

Maybe a problem with the database connection of the report?
Not enough space to save?
Or divison by zero error within the report when saving ?

 

[yksvaan]

Isn't that macro assuming you already have a report open in Impromptu ?

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[lin28]

The macro assumes a report is open.