Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Save Excel worksheet as text from VFP
Message
From
09/05/2001 08:03:44
Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvania, United States
 
 
To
08/05/2001 17:02:14
Jeff Trockman
Lewtan Technologies
Waltham, Massachusetts, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Save Excel worksheet as text from VFP
Miscellaneous
Thread ID:
00505014
Message ID:
00505189
Views:
21
>I need to create a comma delimited text file from an Excel 97 spreadsheet using OLE Automation in VFP. I can't seem to find an example of how to do this.
>

You're on the right track. You do use SaveAs and pass the file format as the 2nd parameter. You probably want a CSV file - the constant for that is 6.

oWorksheet.SaveAs("myfile.txt",6)

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform