cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cristianml Member
Member

Pickup Folder with Power Query

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Jimmy801 New Contributor
New Contributor

Re: Pickup Folder with Power Query

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

View solution in original post

2 REPLIES 2
Jimmy801 New Contributor
New Contributor

Re: Pickup Folder with Power Query

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

View solution in original post

Jimmy801 New Contributor
New Contributor

Re: Pickup Folder with Power Query

Hello @cristianml 

did my proposal help you?

Bye

Jimmy

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)