Solved

Excel  2013 Power Query - Macros

Posted on 2013-11-27
2
1,247 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
look up for 2 numbers of 3 2 34
Excel formula to calculate ID # 4 42
Excel + CountIfs + two colums 5 37
Aggregate data in an EXCEL file. 12 43
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…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

734 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