copy and paste from excel to ppt with VBA

P

PATRIK

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
 
Top