Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how many people are scheduled between... | Excel Worksheet Functions | |||
After Windows update scheduled task uses wrong version of Excel | Excel Discussion (Misc queries) | |||
Run Excel macro from Scheduled Task | Excel Worksheet Functions | |||
Trying to run a MSQuery from Excel as a Scheduled Task | Excel Discussion (Misc queries) | |||
Pivot Table through Scheduled Task | Excel Discussion (Misc queries) |