Syntax for using windows scheduler to open a specific spreadsheet

[matpj]

Hi all,

I am playing around with the windows scheduler and can make it open up excel.
I was wondering if anyone knows the syntax for opening up a specific spreadsheet?

I'm hoping to have a macro in the Workbook Open subroutine so that I can schedule a report to run on a weekly basis.

Thanks in advance,
Matt

[SOS]

Hi matpj,

The way round this that I've found is to point the scheduler to a batch file that contains the lines:

cd\
cd Program Files
cd Microsoft Office
cd Office10
excel.exe c:\source.xls

This batch file will change directory to c:\Program Files\Microsoft Office\Office10 and then opens Excel and the file you specify.

[jo15765]

SOS -- would that be the code to open an Excel 2000 spreadsheet?