VBA Recording Power Query not working

Good afternoon everyone

I am having a problem with Recording a Marco with Power Query

I set up a Excel sheet with Power query in Office 365 working at home
As my work only runs office 2013 I need to know change all the code over I have set up both Office 365 and Office 2013 on my home PC correctly using office 2013

I have been able to set up all my data and tables with naming them all when I do a Marco record same as I did it on office 365 its not saving any of the PQ code

My steps are open sheet Transport click on Cell A1
click Power Query From Table/Range Power Query opens
Click Advanced Editor replace all code with below

Please Login or Register  to view this content.

Close and load to table existing worksheet =Transport!CV1 then load

everything works

when I try and do the same with recording Macro at the end my vba only shows

Please Login or Register  to view this content.

when I used office 365 it looked like below

Any help would be great Still learning how to Code in VBA and use record a lot

Please Login or Register  to view this content.

Good afternoon AliGW

The main reason I went to VBA is to set up a Marco so other staff members at work would just need to click a few buttons and it would all work

I did not know PQ routines can be automated I did a search on google and it points me to office 365 ;-(

You help me a few months ago with pointing me to PQ which has been great learning heaps

A different any help would be helpful

After trying to work this out for the last few hours with setting up all the correct PQ
I have 4 PQ codes that I like to run
first 3 PQ get information from tables sort rename and remove unneeded columns
the 4th one mergers everything in a set way


P.s
sorry what do you mean by PQ code is cammed "M"

AliGW

I think this is a Limit on office 2013

I just tried the same code

On the same excel sheet tried office 365 the same way with record macro and worked

I was reading up on https://stackoverflow.com/questions/...r-query-in-vba

I now get what you mean by PQ code is cammed "M"