Re: OpenSchema(adSchemaTables) from Excel 2007 returns nothing

Ralf Ziller wrote:
"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...

Huh? I was speculatiing, based on the fact that your code worked with
E2003 but failed with E2007, that Excel changed between 2003 and 2007,
while ADO didn't.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.