macro running

[JIM.H.]

Hello,
I have a macro in excel and I need to run it periodically.
How can I do that?
Thanks,
Jim.

 

[Chip Pearson]

Jim,

You can use the OnTime method to execute a macro at a scheduled
time. See www.cpearson.com/excel/ontime.htm for details.

 

[JIM.H.]

Hi Chip,
I actually need to run it once a day, and without letting
anyone launch excel. Can I launch excel and start macro in
an automated way in windows 2000.
Thanks,
Jim.

 

[Frank Kabel]

Hi what yre you trying to do with your macro?
- you may consider using the Windows scheduler for this (or have a look
at some shareware scheduling programs)

 

[JIM.H.]

Macro is attached to an excel file and it takes another
exiting excel file and creates a new file by dividing
source data into sheets and make some calculations in the
new file.

 

[Frank Kabel]

Hi
I would try the following:
- use the windows scheduler
- start Excel with the workbook which contains your macro through the
scheduler
- use the workbook open event to start your macro and to quit Excel
after finishing your macro

 

[JIM.H.]

Thanks Frank, I am new at macro, can you be more specific
at last step. Workbook open event to start macro, how? any
example?

 

[Frank Kabel]

Hi
as a starting point for event macros (workbook_open is an event
procedure) see
http://www.cpearson.com/excel/events.htm