the workbook_Open event will fire when a workbook is opened, so put your code
in the workbook_open event and use the windows scheduler to have excel open
and open the workbook
Excel.Exe "C:\MyFolder\Myfile.xls"
runs excel and opens Myfile.xls
http://www.cpearson.com/excel/events.htm
--
Regards,
Tom Ogilvy
"Lost and Looking for Help" wrote:
I know that i can set up Windows to run Excel at a certain time everyday or
week or what ever. I am wondering if there is a way to schedule excel to
open a file and execute a macro at a certain time each week.
Thanks,
Tim