Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SaveAs Property in Excel
Message
From
30/04/2002 10:42:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Title:
SaveAs Property in Excel
Miscellaneous
Thread ID:
00650853
Message ID:
00650853
Views:
244
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??
Next
Reply
Map
View

Click here to load this message in the networking platform