If I connect via ado in VBA in Excel 2007 to an Excel sheet
(Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\test.xls";Extended
Properties="Excel 8.0;HDR=No;") and call
Set RS = conn.OpenSchema(adSchemaTables)
the Recordset is empty. If I run the same code in Excel 2003 the Recordset
gets filled with the expected data.
Is there a way that I can use the code out of Excel 2007?
I do not want to open the Excel sheet as I just need to copy data from the
sheet which is much much faster via ADO than to actually open the excel
sheet.
