"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