Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i release memory
Hello,
i have an error message: cannot empty clipboard. The Office Clipboard shows that the clipboard is empty. This situation persists even after shutting Excel i ran out of memory after running program that does many ( approx 100) open workbook/(copy/paste)/close workbook operations. The memory usage builds up all the time, although only one workbook is open at a time. is there something i should be doing to release memory when the workbook is closed? thanks for any suggestions k |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i release memory
Try setting all the references that open the workbook object to nothing at
the end of the subroutine, i.e., set oWB = workbooks.add .... code... .... set oWB = nothing http://HelpExcel.com "kurb" wrote: Hello, i have an error message: cannot empty clipboard. The Office Clipboard shows that the clipboard is empty. This situation persists even after shutting Excel i ran out of memory after running program that does many ( approx 100) open workbook/(copy/paste)/close workbook operations. The memory usage builds up all the time, although only one workbook is open at a time. is there something i should be doing to release memory when the workbook is closed? thanks for any suggestions k |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
Is this release buggy? | Excel Discussion (Misc queries) | |||
Release Memory | Excel Discussion (Misc queries) | |||
Type Statements and Memory Release | Excel Programming | |||
Release files from memory?? | Excel Programming |