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
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