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

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
>