Re: OpenSchema(adSchemaTables) from Excel 2007 returns nothing



"Bob Barrows [MVP]" wrote:
I've never used OpenSchema against Excel so I'm a little surprised it
returned anything usable. Did it define worksheets as tables?

Yes, you can access worksheets as tables and OpenSchema returns the names of
those tables.

Anyways I suspect the spread*** structure changed in Exel 2007 and,
since ADO is out of support, the OLEDB provider was not updated to
handle that change. Sorry, I have nothing else to suggest.

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.
.