Thread: list excel wookbooks and worksheets
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
  
Posts: 1,182
Default list excel wookbooks and worksheets
Claus,
Do you know you can do the same using ADO without having to open the
Excel files? The file serves in ADO as the database, and its sheets
serve as the database tables. Thus, filename is returned via Dir() and
SQL for the list of table names.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply With QuoteReply With Quote