PDA

View Full Version : Help!! Excel Data gets cut off when pasting to ppt slide



maytey
10-01-2008, 08:12 AM
Hi,

I have a macro which will paste different data ranges to the ppt slide.
However, it seems that my data gets cut off.
As i am pasting my data as a picture, i believe its because of the format that resulted in my "chopped" off picture.

Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
' Paste chart
PPSlide.Select
PPSlide.Shapes.Paste.Select

When i tried to manually paste special my data to the slides, there are actually a couple of selection. And if i choose the Picture (Enhanced Metafile), my picture will paste nicely.

Is there anyway, where i can modify my script to paste as a picuture (Enhanced Metafile)?

Thanks.

Regards,
May