View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nathan Gutman Nathan Gutman is offline
external usenet poster
 
Posts: 31
Default "Out of memory" when running a Web Query

When I try to run the code below in gets stuck on
Refresh BackgroundQuery and gives Error 7 "Out of memory" message.
Using Win95 and XL97. Nothing else is running.
Can someone help?


With ActiveSheet.QueryTables.Add(Connection:= _
"FINDER;C:\My Documents\Excel Files\yahoo.iqy",
Destination:=Range("A1"))
.FieldNames = False
.RefreshStyle = xlInsertDeleteCells
.RowNumbers = False
.FillAdjacentFormulas = False
.RefreshOnFileOpen = False
.HasAutoFormat = True
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SavePassword = False
.SaveData = True
End With