Variable in Address

[Gordon]

I am trying to use a variable in an address to call up historical
prices for stocks out of Yahoo.

With ActiveSheet.QueryTables.Add(Connection:="URL:htto://finance.
yahoo.com/q/hp?s=ibm", Destination:=Range("A1"))
..Name = "hp?s=ibm"
ect................

Thanking you in advance
Gordon

 

[Dave Peterson]

Maybe...

dim mySym as string
mySym = "ibm"
With ActiveSheet.QueryTables.Add _
(Connection:="URL:http://finance.yahoo.com/q/hp?s=" & mysym, _
Destination:=Range("A1"))
.Name = "hp?s=" & mySym
....etc

htto????

Untested, uncompiled.