No macro for Power Query in Excel 2013

261 Views Asked by At

I installed "Power Query" in Excel 2013. Works fine. However it doesn't support VBA. No code is generated when I try to make a macro with the macro recorder. What I am doing wrong?

1

There are 1 best solutions below

2
On

What I am doing wrong?

Using Excel 2013 in 2022. You should upgrade already.

It will work if you upgrade to 2016.

https://learn.microsoft.com/en-us/office/vba/api/excel.workbookquery

WorkbookQuery object (Excel)

An object that represents a query that was created by Power Query. Introduced in Office 2016.