| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit Query Window
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit links window | Excel Discussion (Misc queries) | |||
| why does edit query button not open query | Excel Discussion (Misc queries) | |||
| MS Query - unable to edit query | Excel Discussion (Misc queries) | |||
| Edit Hyperlink Window | Excel Discussion (Misc queries) | |||
| Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
Threaded Mode
