Hi,
I wanted to find out if there is a way to run/invoke a Power Query using Excel VBA. I have a table of data which I then go onto Power Query manually to transform the data in the desired end state but wanted to see if there is a way to run this query in VBA so that when I assign a button to the macro/vba module it will automatically run the Power query. I am trying to create a spreadsheet for end users in which they can press a macro assigned button that will then transform the data using power query and wanted to see if there is away to avoid all the manual steps
Thanks in advance
I wanted to find out if there is a way to run/invoke a Power Query using Excel VBA. I have a table of data which I then go onto Power Query manually to transform the data in the desired end state but wanted to see if there is a way to run this query in VBA so that when I assign a button to the macro/vba module it will automatically run the Power query. I am trying to create a spreadsheet for end users in which they can press a macro assigned button that will then transform the data using power query and wanted to see if there is away to avoid all the manual steps
Thanks in advance