If you want to change the query, do it first with a variable and have your
macro do the fetch

With Sheets(2).QueryTables.Add(Connection:="URL;" _
& "http://finance.yahoo.com/d/quotes.csv?s=" & _
mysmbol & "&f=snd1t1l1ohgpvqyd&e=.csv", _

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"LightShow" wrote in message
...
I was wondering if there is a way to open the web query window (Data -
Import External Data - New Web Query or Edit Query if one exists) through
VBA?