want to know when report is done printing

[natatbh]

I am printing a report to a file. I want to know when the the printing is done and the file is fully created. How can I check this using vba.

thanks,
natatbh

 

[smedvid]

"One approach" off the top of my head, is to use the FileScript objects to see if the file exists and check the filesize to make sure it is growing in a loop. Once the filesize has stopped growing after a few loops, then the file is most likely done being created. htwh,

Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...