>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,
>StanStan,
Unfortunately that's it. Those two old drives are all we have. What I always do is, after exporting to Excel, open it through Automation and, apart from prettying it up, do an Excel.SaveAs(proper params here). This saves it in the current Excel version.
#DEFINE xlNormal -4143
...
cXLSName = "WhateverSheetNameIwant.xls"
lnFileFormat = xlNormal
lcPassword = ""
lcWriteResPassword = ""
llReadOnlyRecommended = .F.
llCreateBackup = .F.
loWorkbook.SaveAs(cXLSName, lnFileFormat, lcPassword, ;
lcWriteResPassword, llReadOnlyRecommended, llCreateBackup)
loExcel.Quit