Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - memory issues - please help | Excel Discussion (Misc queries) | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
Excel Memory Issues | Excel Discussion (Misc queries) | |||
Out of Memory | Setting up and Configuration of Excel | |||
Out of memory? | Excel Discussion (Misc queries) |