Can a Power Query run a VBA macro?

[bstirling]

Hi,

I was looking for a way to run a VBA macro or other code from a Power Query. Is that possible? It seems like it would be a great function to have as there are times I want to do the transform then act on the data to reset a formula or range etc.

Thanks!
Bruce

 

[Bob Phillips]

No, but you probably don't need to, PQ will have equivalent functionality.

 

[bstirling]

Thanks for confirming the no. That is what I thought.

So the type of VBA that I need to do would be to save the document (I have a query that acts on the results of a PQ), re-establish a range on a worksheet, and calculate the sheet if it is set to manual.

I think what I should do is have VBA do the functions and execute the various PQs (38 of them) in the proper sequence.