Create query using power quering in Excel, but doing it with VBA code

[sofiachr]

Hi,

I want to create a query using power quering in Excel but I want to do it by using <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code only. I have the following:


Worksheets("Lista Trebuchet").Select
Dim lastrowtrebuchet As Long
lastrowtrebuchet = Range("A" & Rows.Count).End(xlUp).Row
Range("A1:T" & lastrowtrebuchet).Select

Selection.Resize(Selection.<wbr style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">Rows.Count + 10, Selection.Columns.Count + 0).Select


Now this is the selection I want to create the query out of, how do I do this using only <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code?

Thank you for your help!

 

[olivierhbh]

Hi,
If you have Excel 2016 (or maybe even 2013, not sure about that) you can use the Macro Recorder to record Power Query actions.
Does that help?
Olivier.

 

[sofiachr]

Hi,

I have 2013 but that was the first thing I tried and it didn´t work...