| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Web Queries on background fail
I have tried to use a macro to launch several webqueries to be run parallel
on the background (async), but I got "Invalid Web Query" error. Any ideas? have anyone tried other methods than QueryTable? I'm using Excel 2000. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple Web Queries on background fail
As usual, post your macro for comments
-- Don Guillett SalesAid Software "poolboy" wrote in message ... I have tried to use a macro to launch several webqueries to be run parallel on the background (async), but I got "Invalid Web Query" error. Any ideas? have anyone tried other methods than QueryTable? I'm using Excel 2000. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple Web Queries on background fail
Here is the macro:
Sub GetShareInfo() For I = 0 To 10 StockCode = Sheets("Codes").Range("A1").Offset(I, 0).Value With Sheets("Codes").QueryTables(I) .Connection = "URL;http://finance.yahoo.com/q?s=" & StockCode .WebSelectionType = xlSpecifiedTables .WebTables = "27" .Refresh BackgroundQuery:=True End With DoEvents Next End Sub "poolboy" wrote in message ... I have tried to use a macro to launch several webqueries to be run parallel on the background (async), but I got "Invalid Web Query" error. Any ideas? have anyone tried other methods than QueryTable? I'm using Excel 2000. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| queries with multiple criteria | Excel Discussion (Misc queries) | |||
| Multiple queries under same connection | Excel Discussion (Misc queries) | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| Multiple Web Queries | Excel Programming | |||
| Multiple queries using *.dqy files | Excel Programming | |||
Hybrid Mode
