VBA & Query

Occasional Contributor
1 Reply





Hope it works, attached is an example. 

In cell A2 you are going to have the file path for the excel file that you want to make the connection with power query.

The FileExcelPath that is in cell A2 could be changed with a VBA code with MSGFileDialogFilePicker.