Hi there,

the macro below with a web query, works fine with my laptop computer at home (with Win7 and Excel 2010 32-bit), but in some places with public (or even paid for) Wifi I get a Script error.

=====================
Private Sub GetData()
Application.ScreenUpdating = False
With ActiveSheet.QueryTables.Add(Connection:="URL;https://www.xxx.com, Destination:=Range("A1"))
.Name = "index"
.FieldNames = False
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.EnableRefresh = False
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = False
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlNone
.WebPreFormattedTextToColumns = False
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = True
.WebDisableDateRecognition = False
.Refresh BackgroundQuery:=False
End With
End Sub
=====================

It's obviously not Excel or my Query or even IE.

Is there some setting that I need to change when using some of these other providers like the Wifi access you get in public places or hotels?

Anybody else is getting this type of problem?

Thanks,
Giaco