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

Click here to load this message in the networking platform