Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help: extracting Execel tables with ADO without reordering them
I'm trying to find a way to extract all the worksheets
(tables) from an Excel workbook and having them returned in the same order in which they're originally defined in the workbook (not alphabetically). The VB.net instruction used is: tables = ccn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, _ New Object() {Nothing, Nothing, Nothing, "TABLE"}) Is there any other way (like query, etc.) to get all the tables? Thanks, Lucia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
table reordering & consolidating | Excel Discussion (Misc queries) | |||
Reordering and combining data | Excel Discussion (Misc queries) | |||
Reordering part of a list with VBA | Excel Worksheet Functions | |||
Extracting info to new tables | Excel Discussion (Misc queries) | |||
Reordering Bars in Bar Graphs | Charts and Charting in Excel |