| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Out of Memory?
Hi All......
I'm working on a Excel97 Program that has several hundred macros. My office computer (833mhz, 512mb RAM) has started giving me a "Microsoft Visual Basic Out of Memory" error message. Sometimes it will go away if I click ok about 20-25 times, sometimes not. The same file runs fine on my laptop (366mhz, 96MB RAM).....just recently MIS put a icon in my systray about "Webroot Spy Sweeper".....might they have finally added the "straw", or could something else maybe be causing this problem. I don't have the same problem on simpler Excel files on the same computer, but DO have it on other complicated files. TIA Vaya con Dios, Chuck, CABGx3 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Out of Memory?
Everything you wanted to know about Excel Memory but were affraid to ask...
http://www.decisionmodels.com/index.htm -- HTH... Jim Thomlinson "CLR" wrote: Hi All...... I'm working on a Excel97 Program that has several hundred macros. My office computer (833mhz, 512mb RAM) has started giving me a "Microsoft Visual Basic Out of Memory" error message. Sometimes it will go away if I click ok about 20-25 times, sometimes not. The same file runs fine on my laptop (366mhz, 96MB RAM).....just recently MIS put a icon in my systray about "Webroot Spy Sweeper".....might they have finally added the "straw", or could something else maybe be causing this problem. I don't have the same problem on simpler Excel files on the same computer, but DO have it on other complicated files. TIA Vaya con Dios, Chuck, CABGx3 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Out of Memory?
That's interesting Jim, thanks, but my problem persists.
My filesize is less than 2MB =INFO("memused") reports less than 5MB The file runs fine on a system that has half the processor speed and 20% the RAM of the offending system with the only other difference being the machine that won't run is Win98SE (on a network) and the little one that will is WINMe stand alone. This would kinda/sorta infer that the problem is machine-related. Also, FYI, I run this file off my pocket Jump Drive,(not the network) so it's "really" the same file that will work on one machine and not on the other.......maybe some kind of a setting in Excel..........the file opens fine on both systems, I just get this Out of Memory" pop-up when I try to go to the VBE. One more thing I just noticed......both systems are Excel97, but the offending one is SR-2 and the one that works is SR-1........could the problem be therein? Vaya con Dios, Chuck, CABGx3 "Jim Thomlinson" wrote: Everything you wanted to know about Excel Memory but were affraid to ask... http://www.decisionmodels.com/index.htm -- HTH... Jim Thomlinson "CLR" wrote: Hi All...... I'm working on a Excel97 Program that has several hundred macros. My office computer (833mhz, 512mb RAM) has started giving me a "Microsoft Visual Basic Out of Memory" error message. Sometimes it will go away if I click ok about 20-25 times, sometimes not. The same file runs fine on my laptop (366mhz, 96MB RAM).....just recently MIS put a icon in my systray about "Webroot Spy Sweeper".....might they have finally added the "straw", or could something else maybe be causing this problem. I don't have the same problem on simpler Excel files on the same computer, but DO have it on other complicated files. TIA Vaya con Dios, Chuck, CABGx3 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Out of Memory?
While the macro is running check out the memory usage in the Task Manager to
get an accurate reading of how much memory Excel I actually using. Caompare this to the addressable memory listed on that site that I sent you. I highly doubt that your issue is machine related. The service pack issue is a more likely cause. The new service pack could be doing something that ups the memory usage... -- HTH... Jim Thomlinson "CLR" wrote: That's interesting Jim, thanks, but my problem persists. My filesize is less than 2MB =INFO("memused") reports less than 5MB The file runs fine on a system that has half the processor speed and 20% the RAM of the offending system with the only other difference being the machine that won't run is Win98SE (on a network) and the little one that will is WINMe stand alone. This would kinda/sorta infer that the problem is machine-related. Also, FYI, I run this file off my pocket Jump Drive,(not the network) so it's "really" the same file that will work on one machine and not on the other.......maybe some kind of a setting in Excel..........the file opens fine on both systems, I just get this Out of Memory" pop-up when I try to go to the VBE. One more thing I just noticed......both systems are Excel97, but the offending one is SR-2 and the one that works is SR-1........could the problem be therein? Vaya con Dios, Chuck, CABGx3 "Jim Thomlinson" wrote: Everything you wanted to know about Excel Memory but were affraid to ask... http://www.decisionmodels.com/index.htm -- HTH... Jim Thomlinson "CLR" wrote: Hi All...... I'm working on a Excel97 Program that has several hundred macros. My office computer (833mhz, 512mb RAM) has started giving me a "Microsoft Visual Basic Out of Memory" error message. Sometimes it will go away if I click ok about 20-25 times, sometimes not. The same file runs fine on my laptop (366mhz, 96MB RAM).....just recently MIS put a icon in my systray about "Webroot Spy Sweeper".....might they have finally added the "straw", or could something else maybe be causing this problem. I don't have the same problem on simpler Excel files on the same computer, but DO have it on other complicated files. TIA Vaya con Dios, Chuck, CABGx3 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Out of Memory?
There is no macro running........I only open the book, right-click on the
MainMenu tab and choose ViewCode, and that's when I get the "Out of Memory" pop-up,....it won't do anything from there....... Vaya con Dios, Chuck, CABGx3 "Jim Thomlinson" wrote: While the macro is running check out the memory usage in the Task Manager to get an accurate reading of how much memory Excel I actually using. Caompare this to the addressable memory listed on that site that I sent you. I highly doubt that your issue is machine related. The service pack issue is a more likely cause. The new service pack could be doing something that ups the memory usage... -- HTH... Jim Thomlinson "CLR" wrote: That's interesting Jim, thanks, but my problem persists. My filesize is less than 2MB =INFO("memused") reports less than 5MB The file runs fine on a system that has half the processor speed and 20% the RAM of the offending system with the only other difference being the machine that won't run is Win98SE (on a network) and the little one that will is WINMe stand alone. This would kinda/sorta infer that the problem is machine-related. Also, FYI, I run this file off my pocket Jump Drive,(not the network) so it's "really" the same file that will work on one machine and not on the other.......maybe some kind of a setting in Excel..........the file opens fine on both systems, I just get this Out of Memory" pop-up when I try to go to the VBE. One more thing I just noticed......both systems are Excel97, but the offending one is SR-2 and the one that works is SR-1........could the problem be therein? Vaya con Dios, Chuck, CABGx3 "Jim Thomlinson" wrote: Everything you wanted to know about Excel Memory but were affraid to ask... http://www.decisionmodels.com/index.htm -- HTH... Jim Thomlinson "CLR" wrote: Hi All...... I'm working on a Excel97 Program that has several hundred macros. My office computer (833mhz, 512mb RAM) has started giving me a "Microsoft Visual Basic Out of Memory" error message. Sometimes it will go away if I click ok about 20-25 times, sometimes not. The same file runs fine on my laptop (366mhz, 96MB RAM).....just recently MIS put a icon in my systray about "Webroot Spy Sweeper".....might they have finally added the "straw", or could something else maybe be causing this problem. I don't have the same problem on simpler Excel files on the same computer, but DO have it on other complicated files. TIA Vaya con Dios, Chuck, CABGx3 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Out of Memory?
What does your task manager say the memory usage on excel is just prior to
opening the VBE and just after? -- HTH... Jim Thomlinson "CLR" wrote: There is no macro running........I only open the book, right-click on the MainMenu tab and choose ViewCode, and that's when I get the "Out of Memory" pop-up,....it won't do anything from there....... Vaya con Dios, Chuck, CABGx3 "Jim Thomlinson" wrote: While the macro is running check out the memory usage in the Task Manager to get an accurate reading of how much memory Excel I actually using. Caompare this to the addressable memory listed on that site that I sent you. I highly doubt that your issue is machine related. The service pack issue is a more likely cause. The new service pack could be doing something that ups the memory usage... -- HTH... Jim Thomlinson "CLR" wrote: That's interesting Jim, thanks, but my problem persists. My filesize is less than 2MB =INFO("memused") reports less than 5MB The file runs fine on a system that has half the processor speed and 20% the RAM of the offending system with the only other difference being the machine that won't run is Win98SE (on a network) and the little one that will is WINMe stand alone. This would kinda/sorta infer that the problem is machine-related. Also, FYI, I run this file off my pocket Jump Drive,(not the network) so it's "really" the same file that will work on one machine and not on the other.......maybe some kind of a setting in Excel..........the file opens fine on both systems, I just get this Out of Memory" pop-up when I try to go to the VBE. One more thing I just noticed......both systems are Excel97, but the offending one is SR-2 and the one that works is SR-1........could the problem be therein? Vaya con Dios, Chuck, CABGx3 "Jim Thomlinson" wrote: Everything you wanted to know about Excel Memory but were affraid to ask... http://www.decisionmodels.com/index.htm -- HTH... Jim Thomlinson "CLR" wrote: Hi All...... I'm working on a Excel97 Program that has several hundred macros. My office computer (833mhz, 512mb RAM) has started giving me a "Microsoft Visual Basic Out of Memory" error message. Sometimes it will go away if I click ok about 20-25 times, sometimes not. The same file runs fine on my laptop (366mhz, 96MB RAM).....just recently MIS put a icon in my systray about "Webroot Spy Sweeper".....might they have finally added the "straw", or could something else maybe be causing this problem. I don't have the same problem on simpler Excel files on the same computer, but DO have it on other complicated files. TIA Vaya con Dios, Chuck, CABGx3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
| Out of Memory | Excel Discussion (Misc queries) | |||
| memory | Excel Programming | |||
| Not Enough Memory | Excel Programming | |||
| The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming | |||
Hybrid Mode
