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

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