Using cell values to pull up web sites

[adsxvii]

I have been pulling data from the New Web Query command, but its kinda slow. If I could change the URL using cell values it would be much faster.
The macro I would use is

Please Login or Register  to view this content.

So basically in the "URL;http://www.nba.com/games/20061213/BOSPHI/playbyplay.html", Destination:= _
I would want to change the date 20061213 to a cell value and same with BOSPHI. Can anyone help me with the coding or let me know if this is possible to do. Thanks in advance guys.

[mudraker]

Date in a1
BOSPHI in b1

Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

change cell reference to suit

[adsxvii]

I tried several different things which none seem to work. I use the simplest example.
[code]
"URL;http://www.nba.com/games/20061213/" & Range("A1") & "/playbyplay.html", Destination:= _
Range("A2"))
[code]
I am getting an error that says http://www.nba.com/games/20061213//playbyplay.html cannot be found, where the A1 info (A1=BOSPHI) is not being recognised.
I am sure it is probably the way I have entered the code. Hope you can help. Thanks in advance.

[mudraker]

This now works
I forgot you cannot modify the URL as part of the one command - that is can not have part text & variables .
Need to set up a variable with the complete URL and then use the variable as the URL

Please Login or Register  to view this content.

[adsxvii]

Thanks so much works perfectly

[mudraker]

I'm glad to hear it solved your problem