Query connection referring to a cell value

Hello all,

I am in my first forrays in working with excel queries and would like some advice. See attached spreadsheet for reference.

I have recorded the queries code. This essentially inputs a range of data from a text file into excel. At the moment this is a specified text file (Metrics-GP22012BahrainR1Trummer.txt) which means that the same data is input every time the macro is run. So the current code looks like this:

Please Login or Register  to view this content.

I would like the file path to refer to a cell ($C$10) so as different .txt files are called up in the query depending on the selections made in the table ($C$3:$C$8). I suppose the code would be something like this:

Please Login or Register  to view this content.

This might not even be possible so simply but any advice anyone could give would be appreciated.

Thanks,

RanaldMetrics_Compare_03.xlsm

I am trying to do the same thing but with a web query and I can either have URL;http://star.finra.org/STAR/Main.aspx?source=starapp&MatterID=20110275622&action=mattersearch" in a cell or just Main.aspx?source=starapp&MatterID=20110275622&action=mattersearch. can I reference the cell as a variable so I can loop through the data?

Please Login or Register  to view this content.

I didn't mean to hijack anything, I thought you solved his question already and it is really similar to mine. I thought they do not want you to start your own question if it is basically the same as someone elses. I am new hear so I am learning the proper etiquette

oh okay thanks for the headsup! sorry for the mistake