How to build a dialogue box that chooses a different Access data source for Excel.
Posted on 2011-09-11
I have several Access data sources with different data.
The names of the Access databases are different
The table structure is identical in all cases.
The data is used in a simple Excel Pivot Table.
When I want to pull different data into the Pivot Table I have to open the data connection and modify the property settings.
This requires confirming all of the inputs.
I want to build a dialogue box that changes the Source database and leaves all of the other properties the same.
Can the connect string be inserted into a module that contains a break to insert the database name by means of a "file open" type dialogue?