Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automatically run macro on a schedual ?

Thread starter mrsandridge
Start date Aug 8, 2002

Status: Not open for further replies.

Aug 8, 2002

mrsandridge

Chemical

What is the best way to automatically run a VBA macro on a scheduled basis ? I tried using the windows task manager on my PC but if one of the macros I want to run is already open on my PC (which is often the case) it prompts to open a new version as read only and waits.

Thanks for any input, Michael