Somehow my post having attached excel file with a possible solution from Friday disappeared. Probably I'm late now, but here it is again (differently from Friday's version, I changed the file format to xlsm and added an Open event to update the query connection string and query text string whenever the file is moved or renamed).
|