ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   why do I have to have the table files.xls open in memory to query (https://www.excelbanter.com/excel-programming/417392-why-do-i-have-have-table-files-xls-open-memory-query.html)

TAD from DBL

why do I have to have the table files.xls open in memory to query
 
I have data tables in separate excel files and I query them from other .xls
files in database functions like dsum, dget, davg.

Should I have to have those data files open even when they are in the same
directory? I thought my database functions like dsum, etc., would just go
out and get the data from the excel tables in the same directory without
opening them. Why won't it do that?


--
Please contact me by email if you have an answer to this question. I
appreciate it.


All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com