Re: OpenSchema(adSchemaTables) from Excel 2007 returns nothing


"Ralf Ziller" wrote:
It is a little odd because it is the same file and the same version of ADO,
so I think there shouldn't be any difference what program does the call... I
think I'll just take out support for Excel 2007 or let 2007 open the Workbook
to read the table names by the (slooow) Excel API.

After adding the fallback code for an empty schema Excel 2007 is happy to
provide me with a filled schema... I really wonder what is different now... I
changed nothing with the ADO code. Perhaps the file was opened in Excel 2003
while I used ADO to access it from Excel 2007. I really get suspicious if it
fixes itself as I never know if the error could surface again.
.