View Single Post
  #1   Report Post  
PATRIK
 
Posts: n/a
Default copy and paste from excel to ppt with VBA


Hello all,
I need to copy a lot of graphs from excel and paste them into a ppt
file using VBA code.

So far, I used this VBA code:

...
Worksheets("Slide01").Range("BB1:BF1").CopyPicture xlScreen, xlBitmap
PPSlide.Shapes.Paste.Select
....

and format of the object in the ppt is a bitmap.

Now I would like to copy the object like a "picture".
How must I change the above VBA code in order to do that? (please
consider that the presentation has a lot of slides, so it should remain
"light")

Thx a lot for your help

Patrik


--
PATRIK
------------------------------------------------------------------------
PATRIK's Profile: http://www.excelforum.com/member.php...o&userid=19905
View this thread: http://www.excelforum.com/showthread...hreadid=379598