Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running an Excel Macro as a Scheduled Task
Hello all,
I'm trying to use the Windows Scheduled Tasks utility to run an .xls and a certain macro within it. I've been able to run the .xls with no problem, but not the macro. In Access, one can do it by adding /x macroname, but no such luck with Excel, apparently. I'd like to have the following macro, ExportAsHTMLAuto(), run through Scheduled Tasks. === Sub ExportAsHTMLAuto() dTime = Now + TimeValue("00:00:05") Application.OnTime dTime, "ExportAsHTMLAuto" Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:= _ "T:\Dan Youngren\System\Engineering.htm" _ , FileFormat:=xlHtml, ReadOnlyRecommended:=False, CreateBackup:=False Application.DisplayAlerts = True Application.OnTime Now + TimeValue("00:00:05"), "Save_Exit" End Sub Sub Save_Exit() Application.Quit ThisWorkbook.Close SaveChanges:=True End Sub === So, 5 seconds after Excel opens, it should save as html, then close 5 seconds later. How do I get this to be run as a Scheduled Task? -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Scheduled task hanging | Excel Programming | |||
Scheduled Task | Excel Programming |