Changing URL in macro

[jsuh3]

Let's say I want the url to change each iteration.

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.google.com", Destination:=Range("$A$1"))

What can I put after the "...google.com" so that the URL is different the next time it runs? I have the loop set up, but I don't know how to join the first part of the url (static) and the second (dynamic).

Thanks in advance.

 

[Tom Urtis]

What do you mean, "different the next time it runs"? Different in what way? What you are searching for, or the destination address seeing as you said "after the ...google.com". Examples of what you are talking about would be useful.

 

[jsuh3]

I actually figured it out. Thanks.