Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
The Instruction at "0x749860a0" referenced memory at "0x00000000" | Excel Discussion (Misc queries) | |||
Very Wierd Execl "Memory" problem | Excel Discussion (Misc queries) | |||
Bogus "Out of memory" Warning in VBE? | Excel Discussion (Misc queries) | |||
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming |