How to copy a chart from Excel to PowerPoint?

by

What you need to do is invoke the PasteSpecial “Keep Source Formatting and Embed Workbook”.

enter image description here

Assume you have already created the charts, and the slides, placeholders/etc., and you have already copied the chart and navigated to the destination slide, and that you have an object like PPTApp to represent the PowerPoint.Application object.

Instead of using the Shapes.PasteSpecial method, you can do this:

PPTApp.CommandBars.ExecuteMso "PasteExcelChartSourceFormatting"

This does not create a link to the Excel document, it embeds a local copy of the document in the PowerPoint Presentation. I think I understand this is your requirement.

Update from comments

Documentation on the ExecuteMso method:

http://msdn.microsoft.com/en-us/library/office/ff862419.aspx

Downloadable document containing the idMSO parameters for each Office Application:

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=6627

NOTE: If you want to do something with the pasted chart after .ExecuteMso you may need to check if the shape is already pasted because .ExcecuteMso is asynchronous (the macro doesn’t know when it’s finished). Another question shows you how to wait for its completion .

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. Somehow it’s not copying [closed]
  3. VBA macro that search for file in multiple subfolders
  4. So, I have 6 “master” files to then divide into 40 separate files
  5. Getting ScriptControl to work with Excel 2010 x64
  6. Application.Match gives type mismatch
  7. Count and Highlight keywords within phrases
  8. Transpose a range in VBA
  9. Protecting cells in Excel but allow these to be modified by VBA script
  10. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  11. Detect merged cells in VBA Excel with MergeArea
  12. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  13. Parse HTML content in VBA
  14. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  15. How do I name a spreadsheet automatically, by referencing two cells?
  16. Excel VBA Delete Rows
  17. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  18. Should I turn .CutCopyMode back on before exiting my sub procedure?
  19. VBA: How to delete filtered rows in Excel?
  20. Determine whether user is adding or deleting rows
  21. How to use VBA SaveAs without closing calling workbook?
  22. Removing the password from a VBA project
  23. Removing special characters VBA Excel
  24. Count the number of rows in another sheet [duplicate]
  25. Getting Excel to refresh data on sheet from within VBA
  26. VBA Password Input with Cancel Function
  27. Finding first blank row, then writing to it
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment