ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Out of memory" when running a Web Query (https://www.excelbanter.com/excel-programming/285796-out-memory-when-running-web-query.html)

Nathan Gutman

"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



All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com