Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to save XLS file as CSV file
Message
 
To
30/05/2006 14:30:20
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01125964
Message ID:
01125979
Views:
19
This message has been marked as the solution to the initial question of the thread.
Hi Mo,

Assuming:
ox=createobject('excel.application')	 && instantiate Excel
then, after opening the appropriate workbook / worksheet...
ox.ActiveWorkbook.SaveAs('myXls2Csv.csv',6) && save as CSV; 6=xlCSV constant
...will save the Excel as CSV


HTH
Vince
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform