Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Erroring on Close
I have a large Excel 2000 application (4 to 7 MB, it can vary) that works
fine on most procedures in it. There is one particular procedure that adds a tempory worksheet and then copies a large range (20 columns x up to 25,000 rows) into the file from another Excel file into it, for some analyzing and easy access. When the procedure is done, it deletes the new sheet with this data, and ends normally. After running this procedure, when you go to close this main Excel file, I get the "Excel has encountered a problem and needs to close..." box of death. If any other procedure has been run, but that one, it closes fine. Seems like a memory problem. Since I am copying a large range, I am sure to use: Application.CutCopyMode = False, at the end of the procedure to clear the clipboard, I believe. Any other ideas? Thanks in advance, Denny |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Erroring on Close
Try copying it in, say, blocks of 5000 rows each instead of all 25000 at once.
On Mon, 21 Feb 2005 19:04:56 -0500, "Denny Behnfeldt" wrote: I have a large Excel 2000 application (4 to 7 MB, it can vary) that works fine on most procedures in it. There is one particular procedure that adds a tempory worksheet and then copies a large range (20 columns x up to 25,000 rows) into the file from another Excel file into it, for some analyzing and easy access. When the procedure is done, it deletes the new sheet with this data, and ends normally. After running this procedure, when you go to close this main Excel file, I get the "Excel has encountered a problem and needs to close..." box of death. If any other procedure has been run, but that one, it closes fine. Seems like a memory problem. Since I am copying a large range, I am sure to use: Application.CutCopyMode = False, at the end of the procedure to clear the clipboard, I believe. Any other ideas? Thanks in advance, Denny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why excel close all files when I just want to close one files | Excel Discussion (Misc queries) | |||
Data Validation Not Erroring with List | Excel Worksheet Functions | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |