Forum Discussion
VBA to Open Power Query and set folder to append .csv files
I would like to automate some functions in Power Query using VBA because users most likely will not know how to use Power Query to do the following. I already have some code where a user selects a fo...
I don't understand the problem. Users should not have to open PowerQuery as long as you have set up that query properly, all they have to do is refresh the query?
JKPieterse Sorry, I did not mention that this process would be used as a first time setup for other users. Not every user knows how to use Get & Transform (Power Query sounds so much better), so, it would just be something to initially gather the data and set the PQ up. I did find some information here https://excelunplugged.com/2018/01/23/modifying-power-query-m-code-with-vba/ that I have not tried yet but hope it will work for what I am doing. I will follow up and update here if it does or does not work.