Scheduled Task

M

Matt.

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.
 
M

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
 
T

Tod

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
 
T

Tod

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
 
M

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.
 
Top