Stop and restart macro(s) programatically

This may be more the case that Windows/Excel is not updating the windowing environment while your macro is running. I have noticed on long running macros that I will sometimes get an new instance of Excel in the Task Bar which subsequently disappears when the macro completes.

Blane...thanks...will look into that as well.

Shg -
Basically, I click a link on another application, which then downloads a file to my temp directory. Then the next link, then the next, etc (up to 40 of these files daily). All that works fine. The problem is that when each file is downloaded, it automatically opens - unless a marco is running (including one running a "wait" or "sleep"). When the macro stops or is completed, the files all open.

I just want to stop all macro activity to give these downloaded files a chance to open, then proceed with the macro, or another one. 10-20 seconds should be more than enough...

I hope that makes sense...

Originally Posted by JP Romano

The problem is that when each file is downloaded, it automatically opens

Maybe you could serialize this. Wait until all of the files are downloaded, then open process each one in turn. Is there some reason why they are being opened automatically when the download is complete?

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!

Thanks... I had tried that unsuccessfully, but will give it another go. Thanks again for your time!

Thanks...I most certainly won't hesitate.
Ran the first test this afternoon, and the end user was quite pleased.