LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
table reordering & consolidating ITian2009 Excel Discussion (Misc queries) 4 March 2nd 09 08:24 AM
Reordering and combining data Chris Excel Discussion (Misc queries) 3 September 4th 08 03:20 PM
Reordering part of a list with VBA [email protected] Excel Worksheet Functions 3 April 16th 07 03:22 AM
Extracting info to new tables Dazed & Confused Excel Discussion (Misc queries) 1 September 19th 06 09:32 AM
Reordering Bars in Bar Graphs [email protected] Charts and Charting in Excel 0 July 18th 06 05:58 PM


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"