Paste Chart Into PowerPoint With Embedded Workbook

  • Thread starter Thread starter Joost
  • Start date Start date
J

Joost

In Office 2007 SP2, you can copy an Excel chart and paste (default) into
PowerPoint. In PowerPoint, a Smart Tag appears next to the pasted chart that
lets you choose from 3 paste options. The one I want is "Excel Chart (entire
workbook)" so that the underlying data is included in the presentation as an
embedded, rather than linked, workbook. But how do I select that paste
option programmatically using VBA?

Also, there don't appear to be any Paste Special options that allow you to
paste the chart with an embedded workbook.

There might be a way to access the Smart Tag programmatically and select
this option, but there's no good documentation on VBA for Smart Tags in
PowerPoint. Moreover, this seems a bit sloppy (like SendKeys).
 
Interesting; this is the exact question I asked on Experts Exchange. Steve,
thanks for the comment, but that doesn't work. I still haven't found a
solution, and I've tried probably 20 or so workarounds. Looks like MS forgot
to add programmatic access to this feature.
 
Back
Top