ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can i display the source of an MS Query list? (https://www.excelbanter.com/excel-programming/345302-how-can-i-display-source-ms-query-list.html)

Grd

How can i display the source of an MS Query list?
 
Hi,

I have an access database to which I link in Excel via MS Query. I would
like to put a heading perhaps through VBA to the database path that is being
used.

But I can't even see where the file is in MSQuery anywhere at all.

Any help appreciated

Thanks in advance

Grd


All times are GMT +1. The time now is 01:38 PM.

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