Named Parameters with OLE and Excel

Keywords: 	 Named Parameters

---

Question:

I need help with positional/named params in Winbatch OLE. Winbatch 99d...

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 

Answer:

	EW.SaveAs(:: Filename="c:\data\excel\junk.xls")

Note the ::

---

Article ID:   W14282

Filename:   OLE with Excel and Named Parameters.txt