Convert Excel file 2003 to 1997

  • Thread starter Thread starter Snig
  • Start date Start date
S

Snig

Hi

Can I convert a 2003-format Excel file into 97-format Excel file
programmatically? The "SaveAs" dialog box of Excel 2003 does save the
file into Excel 97 format. But Can I do this by the Excel/Office Object
Library?

I could convert a Word 2003 file into Word 1997 file by the Object
Library. I used "FileConverters" collection of Word for that. But I am
unable to find such property in case of Excel.

In some newsgroups, someone written that in case of Excel, there is no
such feature exposed. Is it is so, what can be the alternate way to
convert 2003 workbook into 1997 workbook?

Thanks very much.
 
XL97,00,02, and 03, along with MacXL98,01,v.X and 04, share the same
format. There's no conversion necessary - just save as an XL workbook.
 
Well, I think, I would have explained the situation more elaborately.

Actually, I've generated the Excel through XSL, and hence it is in XML
format (as per Office 2003 XML schema); which is readable only through
Excel 2003.

So, now, can we convert this excel file of XML format into a normal
excel file, which can be opened by Excel 97/2K/2K3 ?

Thanks.
 
Can't you open the XML file in excel 2003 and -quote- just save as an XL
workbook ? That's what the man said.
Programmatically yes, if you can do it then a macro can too.

HTH. Best wishes Harald
 
Back
Top