Changing the URL of a web data connection with VB

Hey guys,

So I bit of VB novice so excuse the ignorance. I have looked around through the tips and the FAQ and I was unable to find what I was looking for so I am posting here for your help.

I am working on a project where I am collecting data from a web site. I am using the web site data grab connection that Excel comes with. This is working fine, but I need to do this for many URLs. All of the URLs are the exact same except for the the very last part that goes "php?name=<name here>" so instead of setting each connection to a different URL. I want to create a cell where I can just put the name in that cell and then an activeX button to use the web data connection with the proper URL for that name. I use the macro recording to put the correct process behind the button, but I do not know how to VB change the URL it is using with respect to what is in my name cell.

Here is what I have tried. F2 is the cell my "name" is in and the URL that X is equal to is the URL I am trying to edit with that cell. When I just use the macro to record it puts the URL "URL;<here>",_

Please Login or Register  to view this content.

Thanks for any help you can offer.

& Range("f2") ... I feel stupid now. Thank you very much.

Hmm... That actually doesn't seem to solve all of my problems. When I look at the "connections" I can see that every time I press the button it does create a connection, but it does not use the correct URL, so I guess the "& Range("f2") does not work. Any other suggestions?