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

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

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