Macro URL syntax error

[knebelcm]

Hello,

With this code:

With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;http://finance.yahoo.com/quote/LUV/key-statistics", Destination:=Range("$A$1"))

I want to change LUV into this....

& Range("a1").Value

So I can get any stock but I cant get the syntax to work. Any ideas please?


Also I've been using this code:

With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;http://finance.yahoo.com/quote/" & Range("a1").Value, Destination:=Range("$A$2"))

And it has worked for me, but I wanted to use data from the stocks "key statistics" page but again cant seem to be able to add changes (such as & Range("a1").Value) into the middle of the url

I hope this makes sense

Thanks for reading