Solved

Excel  2013 Power Query - Macros

Posted on 2013-11-27
2
1,155 Views
Last Modified: 2013-12-02
Hi

I want to automate certain Power Query tasks in Excel 2013, I used the Macro recorder to generate macro code but then read an article that mentioned the M Language that underpins
Power Query. Which coding language(s) is/are used to automate Power Query?
0
Comment
Question by:murbro
2 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 39681368
There's currently no VBA support in Power Query. This is something in our future roadmap but not near future yet (i.e. not in 2013).
(Miguel Llopis - Microsoft employee)

M lingo is the only way.
0
 

Author Closing Comment

by:murbro
ID: 39689657
Thanks very much
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question