|
Posted to microsoft.public.excel.programming
|
|
|
Accessing Data from Closed Workbook
Hi Seth,
have a look he
http://www.erlandsendata.no/english/index.php?
d=envbadacwbdbado
Wolf
-----Original Message-----
When I use ADO to get data from closed workbook, I notice
that it actually opens the closed workbook. This is
occurring over a network, and maybe that is the problem?
Anyway, when I create a RecordSet object and open it, it
creates a duplicate file in the VBA Explorer...even if
the actual document is closed. Everytime I open the
RecordSet, another copy of the workbook appears in the
project explorer window! I think this has something to
do with my first point.
Does anyone know what is going on, or where I can go to
find out more information about Excel and ADO (I have not
been able to find a forum in which this issue is
discussed).
Thanks,
Seth
.
|