Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.