[RESOLVED] Processing an Excel File (.xlsx format) with VB6 Code

[George1111]

For many years I have successfully Opened, Read, Created new Excel files with the file extension .xls

Today we have the file extension .xlsx which no longer can be read by my older programs.

Is it just a case of re-compiling my code with a Reference to the newer Excel Versions (which generate .xlsx files by default) ?

Thanks

[George1111]

I am using an ODBC driver Connection

This works

Excel 97, 2003
 
Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};
DBQ=C:\MyExcel.xls; 

Excel 2007
 
Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};
DBQ=C:\MyExcel.xlsx;

I am surprised that I am able to open the xlsx file on a machine which does not have Excel 2007 (or above ) installed on it.

I have Excel 2003 installed on the machine PLUS THE OFFICE COMPATIBILITY PACK - this may be the reason