Automating SaveAs Hotfile using VB

[Chargrams]

Hello,

I'm using an Cognos 6.0, Impromptu HotFile for filtering my reports, and I automated saving my hotfile report as an actual hotfile using visual basic 6.0.
The problem is when I open a report that uses this hotfile, because I keep getting a dr.Watson error.
This is the code I am using in VB

objimpapp.saveas ("C:\newhotfile.ims")

The Dr.watson error is an exception stack error.

I also tried using cognos macros (via cognos script editor).

Can someone please help!
Thanks

Chargrams...

 

[DrSimon]

Don't know about VB but in Cognosscript I use
objimpapp.exporthotfile FileName
and have no trouble with opening reports that use it. One good example needed a cascade of multiple hotfiles to get to the final report and it still worked.

Simon Rouse

 

[Chargrams]

Thanks! I actually was scroungin through the Cognos Macro Reference and found my answer. You can also save the report as a snapshot. I think it's Object.SaveAs(Filename,,True).