Blane - Yeah, I'm trying to wait until they all open, but the problem is still kind of the same - how do I continuously check for the existence of an open file if the file won't open while the macro is running?
Unfortunately, the fact that they open when downloaded is a limitation I have to live with...it's a function of the application I'm working with and it's been made quite clear to me that it will not be changed for any reason!
You could use the OnTime method, and schedule a macro run at 1s intervals. It would check to see what files are open, and reschedule itself to run again until they're all open. When they are, it would run the next macro.
Help has a good example.
Entia non sunt multiplicanda sine necessitate
Thanks... I had tried that unsuccessfully, but will give it another go. Thanks again for your time!
Holler back if you have problems.
Thanks...I most certainly won't hesitate.
Ran the first test this afternoon, and the end user was quite pleased.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
JP Romano 
Register To Reply
Bookmarks