| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to referance data from or to a closed workbook from | New Users to Excel | |||
| Replace data into closed workbook | Excel Discussion (Misc queries) | |||
| Get Data From Closed Workbook | Excel Worksheet Functions | |||
| what exactly prevents INDIRECT from accessing closed worksheets? | Excel Worksheet Functions | |||
| Accessing Data from Closed Workbook | Excel Programming | |||
![Wolf[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
