how do i release memory

[kurb]

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

 

[Guest]

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