| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Out of Memory" Excel 2007 Vista 64
I've been away for VBA for awhile so generated a practice form to get
re-educated with the Controls on a new machine. However closing the Form after testing presents an Out of Memory dialog box back at the VBA design window. No other defect or app failure occurs. I am running Excel 2007 with Vista 64 and 4GB RAM. I checked the archives but found no explicit plea for this specific problem. Any ideas? Thanks Much, Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Out of Memory" Excel 2007 Vista 64
Always unload the form; exiting the sub will not release memory.
In a standard module... Unload UserForm1 -or- In the userform module... Unload Me -- Jim Cone Portland, Oregon USA "SteveM" wrote in message I've been away for VBA for awhile so generated a practice form to get re-educated with the Controls on a new machine. However closing the Form after testing presents an Out of Memory dialog box back at the VBA design window. No other defect or app failure occurs. I am running Excel 2007 with Vista 64 and 4GB RAM. I checked the archives but found no explicit plea for this specific problem. Any ideas? Thanks Much, Steve |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Out of Memory" Excel 2007 Vista 64
On Apr 8, 11:25*am, "Jim Cone" wrote:
Always unload the form; exiting the sub will not release memory. In a standard module... Unload UserForm1 -or- In the userform module... Unload Me -- Jim Cone Portland, Oregon *USA "SteveM" wrote in message I've been away for VBA for awhile so generated a practice form to get re-educated with the Controls on a new machine. *However closing the Form after testing presents an Out of Memory dialog box back at the VBA design window. *No other defect or app failure occurs. I am running Excel 2007 with Vista 64 and 4GB RAM. *I checked the archives but found no explicit plea for this specific problem. Any ideas? Thanks Much, Steve Thanks Jim. I did. And closed all other active apps. But it didn't work. Any other ideas? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Out of Memory" Excel 2007 Vista 64
Restart Excel and then see if unloading the form makes a difference. No other ideas except... xl2003 -- Jim Cone Portland, Oregon USA "SteveM" wrote in message Thanks Jim. I did. And closed all other active apps. But it didn't work. Any other ideas? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Out of Memory" Excel 2007 Vista 64
On Apr 8, 11:54*am, "Jim Cone" wrote:
Restart Excel and then see if unloading the form makes a difference. No other ideas except... xl2003 -- Jim Cone Portland, Oregon *USA "SteveM" wrote in message Thanks Jim. *I did. *And closed all other active apps. * But it didn't work. *Any other ideas? Hey, simply sublime... It worked! Thanks, SteveM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| The Instruction at "0x749860a0" referenced memory at "0x00000000" | Excel Discussion (Misc queries) | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| How to disable "New" "open" menu items in Excel 2007 | Excel Programming | |||
| The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming | |||
Linear Mode
