Get part of URL in web query from a specified cell

Hi,

I have this web query.

Please Login or Register  to view this content.

Is there a way I can replace the part of the URL that says "E40DPL" to a cell that contains "E40DPL"?

So the URL would read somthing like this:

http://www.duskyonline.com/dsc/engin...hp?EngineName=["C1"]

I know that's not the correct way to write it, but that's what I'm trying to accomplish.

Thanks for any help.

You need the concatenate operator "&".

eg: "blahblahblah=" & range("c1").value

What if I had a URL like this

http://www.duskyonline.com/dsc/150HP/engine.html

and I wanted to do this

http://www.duskyonline.com/dsc/(C1)/engine.html

how would I write that?

one way...

"http://www.duskyonline.com/dsc/" & range("C1").value & "/engine.html"