Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting To Excel
Message
From
19/05/2005 10:32:27
 
 
To
19/05/2005 10:18:45
Stan Vaninger
Mitek Industries, Inc
Missouri, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01015815
Message ID:
01015821
Views:
21
Isn't this something to do with what version of Excel you've already got on board? Maybe, despite VFP9, the format of the export result is still not up-to-date with Excel 2000 or whatever you've got.

Terry

>I am using Office 2000.
>
>Export To (lcPathFile) Type XlS
>When I do an export to Excel with type XLS (as shown above) and then open the spreadsheet with excel and save it, I get a dialog that says, "MyFile.xls is a Microsoft Excel 2.1 Worksheet. Do you want to overwrite it with the latest Excel format?"
>
>Export To (lcPathFile) Type Xl5
>When I do an export to Excel with type XL5 and then open the spreadsheet with excel and save it, I get a dialog that says, "MyFile.xl5 is a Microsoft Excel 5.0/95 Workbook. Do you want to overwrite it with the latest Excel format?"
>
>But the XLS and XL5 file types are the only two Excel types in the VFP9 Help file. Both types seem to produce what sounds like ancient formats. Is there a undocumented type that produces an Excel spreadsheet that Office 2000 likes?
>
>Thanks,
>Stan
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform