I have a problem with Cognos scripting.
I am trying to export a report as txt file.
Using the standard script from the help file
Sub Main()
Dim objImpApp As Object
Dim objImpRep As Object
Dim strTextFileName As String
Set objImpApp = CreateObject("CognosImpromptu.Application"
Set objImpRep = objImpApp.ActiveDocument
strTextFileName = "test"
objImpRep.ExportText strTextFileName & ".csv"
Set objImpRep = Nothing
Set objImpApp = Nothing
End Sub
But when running the macro in the script editor I get the error:test!Main(8) - R91 "Object value is set to Nothing"
And in Cognosimprompt u error code: -1003
Does anybody know where this is coming from?
What am I doing wrong?
again I am a complete newbie
Thnx in advance
paul
I am trying to export a report as txt file.
Using the standard script from the help file
Sub Main()
Dim objImpApp As Object
Dim objImpRep As Object
Dim strTextFileName As String
Set objImpApp = CreateObject("CognosImpromptu.Application"
Set objImpRep = objImpApp.ActiveDocument
strTextFileName = "test"
objImpRep.ExportText strTextFileName & ".csv"
Set objImpRep = Nothing
Set objImpApp = Nothing
End Sub
But when running the macro in the script editor I get the error:test!Main(8) - R91 "Object value is set to Nothing"
And in Cognosimprompt u error code: -1003
Does anybody know where this is coming from?
What am I doing wrong?
again I am a complete newbie
Thnx in advance
paul