Hi
I was searching for a simple vba code that open the prompt for change source for query that is xls sheet. I have a lot of query steps that i need to do every time that source is changing. So basically i would like to have macro that does this manual steps for a certain query name (i have a number of them in a workbook):
in the query edit mode, click the source change button:
vba1.png
macro should open the prompt so that i can manually pick the xls file:
vba2.png
also, the data can be in a sheet that have different name than previously, so i have to also navigate to proper sheet/table so that "navigation" prompt would be also nice to open so i can manually choose:
vba3.png
vba4.png
Bookmarks