wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
Hi all,
Using Excel 2016.
I created a connection only in Power Query to table on my worksheet with a single row to be used as a file parameter.
The parameter can be 1 of 2 values based on selection by user and that part is working as expected.
I added a bit of code to the Worksheet Change Event, but it does not seem to be doing anything
It should return the path and name of the new file selected by the user, but it is still showing the last selection.
What am I missing?
Thanks,
-w
Using Excel 2016.
I created a connection only in Power Query to table on my worksheet with a single row to be used as a file parameter.
The parameter can be 1 of 2 values based on selection by user and that part is working as expected.
I added a bit of code to the Worksheet Change Event, but it does not seem to be doing anything
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveWorkbook.Connections("Query - myquery").Refresh
End sub
It should return the path and name of the new file selected by the user, but it is still showing the last selection.
What am I missing?
Thanks,
-w