Scheduling macros to run automatically

[meera chandan]

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

 

[Tom Ogilvy]

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.