timing a recorded macro
 

I have recorded some macros that I will like for it to
run at a given time. Example 01/02/04 at 5.00pm. Is this
possible and where in the recorded macro should I add the
line?
Thanks everyone. This is the only place I have ever got
the correct help from.

timing a recorded macro
 

See Chip Pearson's page on using application.Ontime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy

wendy wrote in message
...
I have recorded some macros that I will like for it to
run at a given time. Example 01/02/04 at 5.00pm. Is this
possible and where in the recorded macro should I add the
line?
Thanks everyone. This is the only place I have ever got
the correct help from.

timing a recorded macro
 

"Tom Ogilvy" wrote...
See Chip Pearson's page on using application.Ontime

http://www.cpearson.com/excel/ontime.htm
....
wendy wrote in message
I have recorded some macros that I will like for it to
run at a given time. Example 01/02/04 at 5.00pm. Is this
possible and where in the recorded macro should I add the
line?

As an alternative to the techniques at Chip's site, it's also possible to
use simple Windows scheduling. Just add an entry in the Schedule Tasks
folder to open Excel with the workbook containing these macros in the Excel
command line. Then write an Open event handler in that workbook to call all
the macros. This would do a better job of ensuring the macros were run,
especially if Excel weren't running just before 5:00 PM.

timing a recorded macro
 

In case you don't know what an open event handler is, you might look at Chip
Pearson's page on Events. (although labelled for xl97, it is pertinent to
xl97 and later).

http://www.cpearson.com/excel/events.htm

David McRitchie has some information on using macros since it appears you
are just getting started.

http://www.mvps.org/dmcritchie/excel/getstarted.htm


Tutorials: (VBA tutorial links are after the excel tutorials)
http://www.mvps.org/dmcritchie/excel....htm#tutorials

Link to Microsoft VBA101 page
http://support.microsoft.com/support...01/default.asp

--
Regards,
Tom Ogilvy


Harlan Grove wrote in message
...
"Tom Ogilvy" wrote...
See Chip Pearson's page on using application.Ontime

http://www.cpearson.com/excel/ontime.htm
...
wendy wrote in message
I have recorded some macros that I will like for it to
run at a given time. Example 01/02/04 at 5.00pm. Is this
possible and where in the recorded macro should I add the
line?

As an alternative to the techniques at Chip's site, it's also possible to
use simple Windows scheduling. Just add an entry in the Schedule Tasks
folder to open Excel with the workbook containing these macros in the
Excel
command line. Then write an Open event handler in that workbook to call
all
the macros. This would do a better job of ensuring the macros were run,
especially if Excel weren't running just before 5:00 PM.