Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: Named Parameters
My script works until the SAVEAS command...
ExcelWS = ObjectOpen("Excel.Application") EWS = ExcelWS.Application EWS.visible = @true EWB = EWS.Workbooks EWB.Open ("C:\Data\Excel\Tech Serv Reporting.xls") EWS.Run("get_daily_category") EWS.Run("'Tech Serv Reporting.xls'!format_wks") EW = EWS.Workbook EW.SaveAs("c:\data\excel\junk.xls")Here's the VB example...
NewBook.SaveAs Filename:=fName
EW.SaveAs(:: Filename="c:\data\excel\junk.xls")Note the ::
Article ID: W14282
Filename: OLE with Excel and Named Parameters.txt
File Created: 1999:10:26:11:23:00
Last Updated: 1999:10:26:11:23:00