Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sandy
 
Posts: n/a
Default Copying an Excel Graph to PowerPoint

I am trying to copy an Excel graph to PowerPoint as a Bitmap.

PowerPoint does not seem to support paste as bitmap via a macro. Excel does
not seem to support copying a graph as a bitmap (it does support coping
worksheet data as a bitmap using the syntax "Selection.CopyPicture xlScreen,
xlBitmap").

How can I copy a graph worksheet from Excel to PowerPoint via VB code?

Thank you.

Sandy
  #2   Report Post  
Oliver Ferns via OfficeKB.com
 
Posts: n/a
Default

Here's how to copy a chart as a bitmap picture from Excel...

From Excel VBA Help:
CopyPicture method as it applies to the Chart object.

Copies the selected object to the Clipboard as a picture.

expression.CopyPicture(Appearance, Format, Size)

expression Required. An expression that returns one of the above objects.

Appearance Optional XlPictureAppearance. Specifies how the picture should
be copied.

XlPictureAppearance can be one of these XlPictureAppearance constants.
xlPrinter. The picture is copied as it will look when it's printed.
xlScreen default. The picture is copied to resemble its display on the
screen as closely as possible

Format Optional XlCopyPictureFormat. The format of the picture.

XlCopyPictureFormat can be one of these XlCopyPictureFormat constants.
xlBitmap
xlPicture default

Size Optional XlPictureAppearance. The size of the copied picture when the
object is a chart on a chart sheet (not embedded on a worksheet).

....and here is how to pastespecial as a picture in Outlook:

......View.PasteSpecial DataType:=ppPasteOLEObject, _
DisplayAsIcon:=msoTrue, IconLabel:="New Bitmap Image"

Should do the trick but you havent stated whether you are working in Excel
VBA, Powerpoint VBA, or stand-alone VB6 App, so I can't offer any useful
code....

Hth,
Oli

--
Message posted via http://www.officekb.com
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Sandy -

Why paste it as a bitmap? If it is displayed at anything but the
resolution of the chart in Excel, it will look horrible. You will have
better results pasting it as a picture, which means metafile. This will
not suffer from distortion if it has to be resized. Even better if you
copy it in Excel as a picture, by holding Shift while clicking on the
Edit menu. Copy becomes Copy Picture. Use the On Screen and As Picture
options.

For more info:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Sandy wrote:

I am trying to copy an Excel graph to PowerPoint as a Bitmap.

PowerPoint does not seem to support paste as bitmap via a macro. Excel does
not seem to support copying a graph as a bitmap (it does support coping
worksheet data as a bitmap using the syntax "Selection.CopyPicture xlScreen,
xlBitmap").

How can I copy a graph worksheet from Excel to PowerPoint via VB code?

Thank you.

Sandy

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Importing Excel Object in Powerpoint technically challanged Excel Discussion (Misc queries) 0 January 31st 05 10:25 PM
pasting excel data in a powerpoint slide James Excel Discussion (Misc queries) 4 January 28th 05 03:23 PM
How do I insert an Excel file into a PowerPoint Presentation slid. Barb Excel Discussion (Misc queries) 1 December 11th 04 05:22 PM
Copying an Excel spreadsheet to a Word document KG Excel Discussion (Misc queries) 1 November 28th 04 08:38 PM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"