Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Impromptu Macro with prompts
Hi I have done until so far for just one city,Calgary. Now how do I feed 300 cities to the report as prompts and save with the city name as part of the output file excel. ---------------- Sub Main() Dim objImpApp As object Dim objImpRep As Object Set objImpApp =...- crndev
- Post #5
- Forum: Cognos solutions
-
Impromptu Macro with prompts
Hi drlex, i am enclosing the sample Sub Main() Dim objImpApp As object Dim objImpRep As Object Set objImpApp = CreateObject("CognosImpromptu.Application") objImpApp.Visible 1 objImpApp.OpenCatalog _ "c:\cognos\samples\outdoors.cat","Creator",,,,1 Set objImpRep = _...- crndev
- Post #4
- Forum: Cognos solutions
-
Impromptu Macro with prompts
Thanx Drlex, I am kinda new to this subject. I want to pull from database to provide the list (300 cities). Could you please give me more step by step process. How does the macro look like for example? Array as u said, makes sense, but how to implement it as a code? Thanku- crndev
- Post #3
- Forum: Cognos solutions
-
Impromptu Macro with prompts
Hello I have an impromptu report, with prompt on one column(City). There are basically 300 different cities. I have to create a Macro, to run this impromptu report, and have the city entered 300 times ( each city, for each time) and get it saved (excel format) with the city as a part of the...- crndev
- Thread
- Replies: 6
- Forum: Cognos solutions
