Hi Garry,

Am Wed, 07 Oct 2015 14:21:42 -0400 schrieb GS:

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.

and how do I get a cell value?


Regards
Claus B.

If the cell has a defined name it doesn't need to be at a specific
address. For example, if the workbooks contain quotes/estimates of
various numbers of items, the SubTotal, Tax, and Total can be anywhere
on the sheet. You can use the defined name in the ADO query as the
range ref when the address will be unknown...

--
Garry

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