Cannot copy Excel 2007 Chart and Paste as Bitmap into Powerpoint 2
in [Charts]
|
Prev: 432956 M3i Zero , Ezflash Dsi , R4i Dsi 72404
Next: Cannot copy Excel 2007 Chart and Paste as Bitmap into Powerpoi
From: SysMod on 29 Sep 2009 06:54 A client with a Mac complains that my chart pictures in Powerpoint are distorted. The text appears badly spaced. My guess is the Mac does not like the MS Metafile picture type. My code has: ActiveChart.CopyPicture Appearance:=xlScreen, Size:=xlScreen, Format:=xlPicture Set PasteSlideShape = mPPSlide.Shapes.PasteSpecial(PasteDataType) where I have tried all values of 0..11 for the DataType parameter But I get for type 2 (bitmap) 'Run-time error '-2147188160 (80048240)': 'Shapes (unknown member) : Invalid request. The specified data type is unavailable. only datatypes 0,2,3 work. I use 0 (default, which is the same as Metafile) I've googled for this and got these refs: Excel 2007 copy chart as bitmap cannot paste as ppBitMap into Powerpoint 2007 http://www.pcreview.co.uk/forums/thread-3883121.php PasteSpecial of Device Independent Bitmap with VBA in PP2007 in the full list of Excel 2007 SP2 fixes we see : The VBA method Selection.CopyPicture does not copy the bitmap picture format to the clipboard. Excel..About says I have SP2 http://www.ozgrid.com/forum/showthread.php?t=73114 Re: Picture Copied as BitMap Ends Up As Metafile Andy Pope says: "For me in 2007 this code copies the chart as a bitmap and pastes into powerpoint as expected." ActiveSheet.Shapes(1).CopyPicture Appearance:=xlScreen, Format:=xlBitmap objPPTSld.Shapes.PasteSpecial ppPasteBitmap but I get the error as shown above. Any ideas? TIA Patrick |