Pickup Folder with Power Query

[cristianml]

Hi team,

I was trying to find a way to use a pick up folder option like with a Macro but using Power query.. Is this possible ?

This is a code in VBA to pick up folder. I would like to replace this using power query and also using with RELATIVE FILE PATH : 

VBA CODE:
'Retrieve Target Folder Path From User
Set FldrPicker = Application.FileDialog(msoFileDialogFolderPicker)

With FldrPicker
.Title = "Select a Target Folder"
.AllowMultiSelect = False
If .Show <> -1 Then GoTo NextCode
myPath = .SelectedItems(1) & "\"
End With

'In Case of Cancel
NextCode:
myPath = myPath
If myPath = "" Then GoTo ResetSettings

'Target File Extension (must include wildcard "*")
myExtension = "*.xls*"

'Target Path with Ending Extention
myFile = Dir(myPath & myExtension)

The idea is to use a this FileDialog folder picker option but in power query and combine it with the normal option in power query that is to get data from a Folder option. 

Any ideas ? Thanks.

[Jimmy801]

Hello @cristianml 

did my proposal help you?

Bye

Jimmy

[Jimmy801 · Accepted solution]

Hello

this dialog box can't be replaced by PQ.

Possible solution is

- use vba and the filedialog

- use the output of the vba to fill a table.

- read this table and use it as parameter for the folder-function.

you can write a VBA that after filling the path-information to the table, runs automatically a refresh of the PQ.

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy