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.