Auto Starting Excel

[Guest]

Hi

Does anyone know if there is a way to have Excel open at a certain time (e.g
0900) and have it open a Macro to run.

I have files which are auto loaded to a shared area but need to run the
Macro's on them, I cant leave my PC on 24/7 but would like the Excel document
to auto-open and run the Macro on a server.

Can any one assist?

Thanks
Drew

 

[Gord Dibben]

Use Windows Task Scheduler to start Excel with a shortcut to the workbook in
question.

Run the macro from a Workbook_Open event in the workbook.


Gord Dibben MS Excel MVP