Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
some exotic error
how to fix something like that:
Sub getquery() a = "URL;http://www.bankier.pl/inwestowanie/profile/wynikifinansowe/01NFI-jednostkowy-raport-kwartalny.html?offset=0" b = "any_name_01" With Sheets("query").QueryTables.Add(Connection:=a, Destination:=Sheets("query").Range("A1")) .Name = b .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = False .RefreshOnFileOpen = False .BackgroundQuery = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = False .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = "1" .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False 'ERROR LINE ??? End With End Sub and error sounds: Run-time error '-2147417848 (80010108)' Automation Error The object invoked has disconnected from its client. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exotic jewelry box | Excel Discussion (Misc queries) | |||
Exotic Menu Controls | Excel Programming | |||
A Chart for breeding, incubation, eggs, of exotic birds | Excel Discussion (Misc queries) | |||
Exotic Bets Spreadsheet - Need Help! | Excel Discussion (Misc queries) | |||
Exotic CheckBox | Excel Programming |