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.

You can create a vbscript and point the scheduled task to
that script. Here's an example of a script that opens a
workbook, runs a procedure in the workbook called Main,
then closes the workbook.

Dim xl
Dim CurrentBook

Set xl = CreateObject("Excel.Application")
Set CurrentBook = xl.Workbooks.Open
("C:\MyPath\BookName.xls")
xl.Run "Main"
CurrentBook.Save
CurrentBook.Close
xl.Quit

set CurrentBook = nothing
set xl = nothing

tod
-----Original 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.


.

Thanks Tod, I'll take your advice. When I run the VB Script, my Main
function currently displays a message box. But the Excel doesn't show up on
the task bar anywhere. Is that normal?

Any recommendation on anything else?

cheers,
Matt.

"Tod" wrote in message
...
You can create a vbscript and point the scheduled task to
that script. Here's an example of a script that opens a
workbook, runs a procedure in the workbook called Main,
then closes the workbook.

Dim xl
Dim CurrentBook

Set xl = CreateObject("Excel.Application")
Set CurrentBook = xl.Workbooks.Open
("C:\MyPath\BookName.xls")
xl.Run "Main"
CurrentBook.Save
CurrentBook.Close
xl.Quit

set CurrentBook = nothing
set xl = nothing

tod
-----Original 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.


.

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.

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.




.