PDA

View Full Version : Using automation with PRF files


Melissa2
September 9th, 2002, 03:34 PM
Hello,

I am using VBA in Excel to automatically open a PRF file that contains several reports. The report that I need to print is not in the report window when the PRF file is first opened. Is there a way to specify which report in a PRF file that appears first? Right now I use Findtext to see if the report I need is in the PRF file, but I can't get Monarch to make the report in which the text is found the current report in order to use MonarchObj.PrintReport. Is this possible? I hope I have made my problem clear.

Thanks,

Melissa

Melissa2
September 10th, 2002, 12:53 PM
Never mind...I figured it out. The reports in my PRF file are extracted to my temp directory so all I have to do is have VBA check the temp directory for that file and if it exists then use SetReportFile to be able to print it.

Melissa