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
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