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/