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?
Asked
Active
Viewed 224 times
0
-
The fact that the macro recorder doesn't create any code doesn't mean that it is not possible. – FunThomas Apr 08 '22 at 07:23
-
In excel 2016 creation is fine. – John Apr 08 '22 at 10:23
-
And have you tried to run the code that the recorder created on a computer with 2016 on a computer that runs 2013? – FunThomas Apr 08 '22 at 11:34
-
It doesn't work either – John Apr 09 '22 at 09:47
1 Answers
0
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.
TheRizza
- 1,577
- 1
- 10
- 23
-
You can install "power query" in excel 2013. However vba2013 is not quite compatible. – John Apr 16 '22 at 06:51
-