Need to run a macro at a specified frequency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a need to run a macro at a specified frequency (maybe once a week or
once every couple of weeks). I don't want to have to have someone manually
run this each time. I want it to run automatically. Does anyone have any
suggestions as to how this would be accomplished? I've seen some things
with Application.OnTime, but that seems to assume that the workbook is open.
I'd like to have this automatically open a workbook and run it when the time
is right.

Thanks in advance for your assistance,

Barb Reinhardt
 
Barb,

Try using Windows XP task manager to open the workbook at your desired
frequency with the code you need to execute called from (or in) in the
workbook_open event.

Mike
 
Where would I find information on how I'd use the task manager to do this?

Thanks,
Barb
 
I figured it out. Thanks.

Mike H said:
Barb,

Try using Windows XP task manager to open the workbook at your desired
frequency with the code you need to execute called from (or in) in the
workbook_open event.

Mike
Click to expand...
 
Back
Top