Scheduled Task
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.
|