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

"Barb Reinhardt" wrote:

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

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

Thanks,
Barb

"Mike H" wrote:

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

"Barb Reinhardt" wrote:

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

I figured it out. Thanks.

"Mike H" wrote:

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

"Barb Reinhardt" wrote:

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