VBA macro code for Opening a particular xlslx file from power query

[NimishK]

Any VBA code for Opening a particular xlslx file from power query


Using Excel 2013 few days back installed power query


1. In excel I click on Power Query
2. then click on From File
3. then click From Excel
so i get option to choose the file . (in fact thru macro i want directly to open)


What is the macro code for the above 3 steps ? So step by step with correct syntax i can reach my objective.


What i would like is to, with macro code, directly open the same file with format i require in power query.
This will stop my addtional working on another step to open the file and re structure the format.


Regards
NimishK

 

[macfuller]

I assume you have tried the macro recorder and it didn't return any code. I don't believe you can execute individual Power Query steps from within VBA.

Once you have created the query, of course you can refresh it via VBA. But it sounds like you want to have a quick way to open a new query that points to an Excel file. You could create a generic preliminary query within Power Query with those 3 steps and go to it directly via the Query editor, then copy the resulting customizations to a new query.

 

[horseyride]

I suggest SendKeys
See https://www.contextures.com/excelvbasendkeys.html

 

[NimishK]

Macfuller:

I don't believe you can execute individual Power Query steps from within VBA.

Somewhere some PQ commands/Syntaxes will be there within VBA or MS-VBA have not incorporated them at all.

Anyways Thanks Macfuller and HorseyRide for your replies.