Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"On Error" not working for web queries
Why does "On Error" seem to make no difference? Once every few hundred web
queries will fail because of some timeout or webpage not being available but the "On Error" doesn't seem to help. The error is always on the last line: ".Refresh BackgroundQuery:= False". Any insight would be appreciated. Regards, Brian code excerpt........................................... ............................... On Error GoTo query3error With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://finance.yahoo.com/q?s=" & ticker, Destination:=Range("A1")) .Name = "q?s=" & ticker .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = False ' was True .RefreshStyle = xlOverwriteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .webtables = webtables(trials - 1) ' was "16" .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = True ' was False .Refresh BackgroundQuery:=False End With -- Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
Working out age from "Day" "Month" "Year" | Excel Worksheet Functions | |||
"on error resume next" NOT working... | Excel Programming | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming |