Create multiple queries and content to get from excel table

[vivis93]

Hi
it is possible to create multiple queries and the content

let    Source = ""
in
    Source

to get from a table in excel i need this to create more than 150 queries so its a pain i hope that with vba code this can be done with a click of buton.
All the best

 

[ImkeF]

In Excel 2016 there is a VBA object model: Power Query/Excel 2016 VBA Examples | Chris Webb's BI Blog

Are you sure that you cannot reduce the number of queries?
Multiple Input files:
a) Iterating over multiple pages of web data using Power Query | Matt Masson
b) Super Power Query 3

Multiple Outputs:
Create a column with the field that carries the distinctive value and then filter instead.