I have looked at your PowerQuery M classes https://github.com/RelaxTools/Hidennotare/wiki/MCommand. Is there a way to load the command into the PowerQuery Editor, or assign it as the source of a new pivot table or list object? This way I can automate the creation of a powerquery table from VBA.
Excellent tool, thank you :)
I have looked at your PowerQuery M classes https://github.com/RelaxTools/Hidennotare/wiki/MCommand. Is there a way to load the command into the PowerQuery Editor, or assign it as the source of a new pivot table or list object? This way I can automate the creation of a powerquery table from VBA.
Excellent tool, thank you :)