Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: XLS macro
;Code that launches an Excel macro ;Define .XLS file xls = "C:\Temp\Data\test.xls" ;MacroName = "Macro1" ;or MacroName = "test.xls!Macro1" objXL = ObjectCreate("Excel.Application") objXL.Visible = @TRUE objXL.DisplayAlerts = @FALSE ;Open XLS file objWorkbooks = objXL.Workbooks objWorkbooks.open(XLS) ; execute macro code objXL.Run(MacroName) objWorkbooks = 0 objXL = 0 Exit
Article ID: W15642
File Created: 2009:08:12:09:29:50
Last Updated: 2009:08:12:09:29:50