Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule a Macro
Once you have opened the file then how do you automatically run the macro?
Jim "Frank Kabel" wrote in message ... Hi Excel has to run for this (with the file containing the macro). See: http://www.cpearson.com/excel/ontime.htm If this is not what you're looking for you may use the Windows Scheduler (or any other scheduling program) for this -- Regards Frank Kabel Frankfurt, Germany Koen Vanbever wrote: Hi, Is it Possible to Schedule a Macro. e.g. I want to execute a macro everery week Mondays at 12.00 h. Now I can startup the XLS-file an execute the macro but I only want to start up the Macro! Greetings, Koen Vanbever |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule a Macro
Hi
put the code in the workbook_open event. See: http://www.cpearson.com/excel/events.htm -- Regards Frank Kabel Frankfurt, Germany Jim Simpson wrote: Once you have opened the file then how do you automatically run the macro? Jim "Frank Kabel" wrote in message ... Hi Excel has to run for this (with the file containing the macro). See: http://www.cpearson.com/excel/ontime.htm If this is not what you're looking for you may use the Windows Scheduler (or any other scheduling program) for this -- Regards Frank Kabel Frankfurt, Germany Koen Vanbever wrote: Hi, Is it Possible to Schedule a Macro. e.g. I want to execute a macro everery week Mondays at 12.00 h. Now I can startup the XLS-file an execute the macro but I only want to start up the Macro! Greetings, Koen Vanbever |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule a Macro
Thanks Frank for your help.
Jim "Frank Kabel" wrote in message ... Hi put the code in the workbook_open event. See: http://www.cpearson.com/excel/events.htm -- Regards Frank Kabel Frankfurt, Germany Jim Simpson wrote: Once you have opened the file then how do you automatically run the macro? Jim "Frank Kabel" wrote in message ... Hi Excel has to run for this (with the file containing the macro). See: http://www.cpearson.com/excel/ontime.htm If this is not what you're looking for you may use the Windows Scheduler (or any other scheduling program) for this -- Regards Frank Kabel Frankfurt, Germany Koen Vanbever wrote: Hi, Is it Possible to Schedule a Macro. e.g. I want to execute a macro everery week Mondays at 12.00 h. Now I can startup the XLS-file an execute the macro but I only want to start up the Macro! Greetings, Koen Vanbever |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Schedule Macro doesn't seem to run any suggestions | Excel Discussion (Misc queries) | |||
Macro for creating a schedule | Excel Discussion (Misc queries) | |||
Schedule a Macro to run every 5 minutes | Excel Discussion (Misc queries) | |||
Schedule an Excel macro | Excel Discussion (Misc queries) | |||
Schedule a macro running | Excel Discussion (Misc queries) |