Don't use the task scheduler to open Excel. Instead, give
it the path of the vbscript. The script code will open the
your workbook. Your OS is configured to open Excel by
default.

tod

-----Original Message-----
This seemed to do it. But Book 1 still opens (after the
file.....).

"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e
c:\test.xls

cheers,
Matt
"Matt." wrote in
message
. ..
Hi all!

I would like to use the Task Scheduler to open a
specific Excel File. Can
somebody give me a sample of the correct syntax? And
prevent it from
opening Book 1, too?

The reason? I need to schedule a periodic query of a
SQL Server database,
read the data into Excel, save the spreadsheet with a
unique name
everyday,
and then email the resultant spreadsheet to a list of
people, and then
close
the Excel spreadsheet, and exit Excel. I know how to
do most of the above
with VBA, but I can't get the syntax right for the
scheduler. I haven't
actually started the programming for this yet. If
somebody has some tips
to
performing this task, I would greatly appreciate it.

cheers,
Matt.




.