Scheduling macros to run automatically
 

Hi

I have a whole set of macros that i need to run everyday
at work that takes about 1.5 hrs to run... Is there anyway
that I can schedule certain macros to run at certain times
during the day everyday? Can this be done in Excel or do
we need to use VB professional to program something like
this? I would appreciate any help with this because I do
not know where to start with this.

Thanks,
Meera

Scheduling macros to run automatically
 

Look at Chip Pearson's application.ontime example

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

You can use the workbook_Open event to run code when a workbook is opened

you can use the window's schedular to have windows open a workbook/start
excel at a certain time.


--
Regards,
Tom Ogilvy


"meera chandan" wrote in message
...
Hi

I have a whole set of macos that i need to run everyday
at work that takes about 1.5 hrs to run... Is there anyway
that I can schedule certain macros to run at certain times
during the day everyday? Can this be done in Excel or do
we need to use VB professional to program something like
this? I would appreciate any help with this because I do
not know where to start with this.

Thanks,
Meera