Running Impromptu Macro ??

[zxzzzzzz]

I have an Impromptu macro that runs; however, I am going to need to incorporate running it into my job scheduler. The first step is.... How can I run this macro from the command line? I tried what the documentation suggested, but it didn't work.

Here is the macro:

Sub Main ()
Dim objImpApp as object
Dim objImpRep as object
Set objImpApp = Createobject
"CognosImpromptu.Application&quot
ObjImpApp.OpenCatalog "k:\Catalogs 7.0
\DMSU_data2.cat", "Developer"
Set objImpRep = objImpApp.OpenReport ("k:\DMS CUSTOM
REPORTING\PO SUMMARY REPORT.imr&quot
objImpRep.RetrieveAll
objImpRep.Print
objImpRep.CloseReport
objImpApp.Quit
Set objImpRep = Nothing
Set objImpApp = Nothing
End Sub

THANKS!!!!

 

[griffindm]

GB65,

You did not elaborate, but I shall assume your attempt following the documentation involved running RunMac32.exe from the command line with the COMPILED macro (i.e. the file with a .MCX extension) as an argument following the RunMac32.exe. If long file names are involved for the macro or the runtime file names or locations, it would not hurt to enclosed that portion of the call (either the exe or the macro argument) in double quotes.

Please get back to the forum with what you actually did and what the results or error messages that resulted are.

HTH,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[zxzzzzzz]

This is my very first Cognos macro, and it was run within Cognos Script Editor - compile - Run. I read in the help documentation something about running from a command line using Start - Run - type the path and macro name and something about using -m before the command. There were no samples, and the documentation didn't go into detail. That is as far as I got.

Sorry for so little info, but this has been trial and error for several weeks now on this macro stuff. Nobody here at my work knows even a little about Cognos anything.

THANKS!