LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default Web query causes excel crash!

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL2007 crash using MS Query in vista 64 EddieO Excel Discussion (Misc queries) 0 July 13th 09 07:02 PM
Excel Crash when MS Query Add-in is enabled Mike@Syrris Excel Discussion (Misc queries) 0 February 23rd 06 03:50 PM
Excel Crash - Help! Delbert Excel Discussion (Misc queries) 13 December 13th 05 10:02 PM
Excel crash HELP! Eric Excel Programming 0 November 5th 04 03:34 PM
Excel Crash Seth[_3_] Excel Programming 1 October 31st 03 01:59 PM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Š2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"