Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, excel 2007 crashes while following web query (via VBA) is about to start:
======== a = URL;http://www.bankier.pl/inwestowanie/p....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 = xlEntirePage .WebFormatting = xlWebFormattingNone .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False 'ERROR LINE ??? End With ======== month ago this module worked perfectly (in loop) - this time something from the site may cause this crash. could you create and check web query via VBA and commonly via query creator and pull data from the link: (link is safe, it is Polish daily financial e-bulletin) http://www.bankier.pl/inwestowanie/p....html?offset=0 i do not have idea what may cause "application shutdown and windows error reporting" regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XL2007 crash using MS Query in vista 64 | Excel Discussion (Misc queries) | |||
Excel Crash when MS Query Add-in is enabled | Excel Discussion (Misc queries) | |||
Excel Crash - Help! | Excel Discussion (Misc queries) | |||
Excel crash HELP! | Excel Programming | |||
Excel Crash | Excel Programming |