Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to run automatically
On Wed, 30 Jul 2003 11:25:34 -0700, "Karon" wrote in
microsoft.public.excel.programming: is it possible to have a macro run on it's own on a daily basis without having to open the spreadsheet? Yes. 1. Create a VBS file along these lines: Set myApp = WScript.CreateObject("Excel.Application") Set myBook = myApp.WorkBooks.Open("d:\path\workbook.xls") myApp.Run("MyMacro") myBook.Save ' if you want/need to Set myBook=nothing myApp.Quit Set myApp = Nothing 2. Schedule a job (CSCRIPT.EXE) to run the above. -- Michael Bednarek, IT Manager, Tactical Global Management Waterfront Pl, Brisbane 4000, Australia. "POST NO BILLS" http://mcmbednarek.tripod.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you do the following using VBA macro automatically? | Excel Discussion (Misc queries) | |||
macro run automatically | Excel Discussion (Misc queries) | |||
Automatically Run macro | Setting up and Configuration of Excel | |||
Macro to automatically run | Excel Discussion (Misc queries) | |||
Run macro automatically. | New Users to Excel |