Memory Issues
 

John

Following should eliminate the use of Word
to copy the bitmap.


Also notice application.cutcopymode=false
doesn't clear pictures from the "infamous"
Office Clipboard.

i've included a usefull proc that does it..
but it'll work for office2000 only!

if i'll find a working method to clear the
officeXP clipboard i'll let you know.


Sub copyBmp()
Range("a1:d10").CopyPicture xlScreen, xlBitmap
End Sub

Sub copyEMF()
Range("a1:d10").CopyPicture xlScreen, xlPicture
End Sub

Sub ClearClip()
On Error Resume Next
Application.CommandBars("Clipboard").Controls(4).E xecute
On Error Goto 0
End Sub


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John Flynn" wrote:

I have an excel application that transfers excel worksheet
images (portions of a worksheet) into PowerPoint which has
a corresponding "catcher" macro.

I must first paste the image in Word as a bitmap then copy
it to PowerPoint (you cannot do a paste special in
PowerPoint via a macro).

The issue is that after about 25-30 transfers the process
fails because of insufficient memory. I then close
everything and reopen and resume until done or until it
fails again. I repeat this process until all images are
transferred.

Are there any commands that will recover memory or clear
the clipboard or whatever it is that causes this issue.

Thanks.