Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
How to FIX Recorded Macro | Excel Discussion (Misc queries) | |||
Possible Macro Timing Overrun generates Excel Exception | Excel Discussion (Misc queries) | |||
Timing a macro | Excel Discussion (Misc queries) | |||
Excel 2003 has wrong timing using the worksheet_change macro | Excel Worksheet Functions |