GetOleDbSchemaTable: Exclude named ranges from Excel
When extracting Excel worksheet names using GetOleDbSchemaTable, is there a
way to exclude named ranges in Excel from the result ?
I'm only interrested in getting worksheets returned in the table collection.
Any help would be greatly appreciated.
Thanks in advance,
Thomas
|