Increment Variable in Power Query

[alsdkjfladjfgj12321]

I am using VBA to make connections in Power Query, put a file name + extension in a cell, and rename the cell (Query1, Query2, Query3....). The macro runs fine. The part that I can't figure out is how to increment the variable in Power Query. It remains Query1 for connections that are made. It is hard coded in. I want to run the VBA be able to have the M code in each connection have Query1, then loop again to get Query2.

I hope what I described is clear.

 

[peter789]

I would recommend you follow Sany666's suggestion. But to answer your question about appending the files Power Query should do that for you. The only proviso is that all the files have the same format; however, looking at your sample of code I suspect that is the case.
In my opinion VBA has limited use when you are using M language. I think you are trying to "push" data into PQ; let PQ do all the work from the "Get" point of view.
Peter

 

[alsdkjfladjfgj12321]

I think I'll have to look into that to see if that will work.