Ian,
xlCSV is constant in VBA. Try the following:
#DEFINE xlCSV 6
.ActiveWorkbook.SaveAs("C:\NewFile.csv", xlCSV)
>I am trying to open an Excel 2000 or any Excel spreadsheet and save it as a CSV file. I have tried:
>ObjExcel= CREATEOBJECT("Excel.Application")
>with ObjExcel
>.Workbooks.Open("C:\MyFile.xls")
>.ActiveWorkbook.SaveAs("C:\NewFile.csv", "xlCSV")
>endwith
>ObjExcel.Quit
>release objexcel
>
>I keep getting a OLE IDispatch execution Code 0; Unable to get the SaveAs Property of the Workbook Class. Help??
Daniel