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.
You query the range. Here's an example tutorial by Rob Bovey, one of
the authors of *Pro Excel Development*...
http://www.appspro.com/conference/Da...rogramming.zip
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion