ExcelBanter - Data Source for MS Query

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Source for MS Query (https://www.excelbanter.com/excel-discussion-misc-queries/90371-data-source-ms-query.html)

Suzseb

Data Source for MS Query

I have several Excel files that I'm using Query with. I'd like to have a set
each month and be able to just go in and run the same query with a different
data source (Excel database file). Is this possible? I can't seem to find a
way to change the data source without creating a new query.

Thanks,
--
Suz

All times are GMT +1. The time now is 11:01 AM.