hallo together.
i work with cognos impromptu 7.4 and i want to use an macro to export my report into xls-file.
i have 2 variable which i have to enter manual when report open.
when i use my macro the report open but the script stop by asking for the variable an i have to press OK manual.
part of my code:
promptval1 = strVar1+","+strVar2
ErrorCount = 0
Set objImpApp = CreateObject("Impromptu.Application")
Set objImpRep = CreateObject("Impromptu.Application")
objImpApp.Visible -1
objImpApp.OpenCatalog strCatalog, "Endanwender"
Set objImpRep = objImpApp.OpenReport(strReport,promptval1)
objImpRep.RetrieveAll
objImpRep.ExportExcelWithFormat (strFile)
objImpRep.CloseReport
objImpApp.Quit
Set objImpApp = Nothing
Set objImpRep = Nothing
how can i open the report, set the variable an export the report to exel automatically
thanks a lot
i work with cognos impromptu 7.4 and i want to use an macro to export my report into xls-file.
i have 2 variable which i have to enter manual when report open.
when i use my macro the report open but the script stop by asking for the variable an i have to press OK manual.
part of my code:
promptval1 = strVar1+","+strVar2
ErrorCount = 0
Set objImpApp = CreateObject("Impromptu.Application")
Set objImpRep = CreateObject("Impromptu.Application")
objImpApp.Visible -1
objImpApp.OpenCatalog strCatalog, "Endanwender"
Set objImpRep = objImpApp.OpenReport(strReport,promptval1)
objImpRep.RetrieveAll
objImpRep.ExportExcelWithFormat (strFile)
objImpRep.CloseReport
objImpApp.Quit
Set objImpApp = Nothing
Set objImpRep = Nothing
how can i open the report, set the variable an export the report to exel automatically
thanks a lot