Paste Special in Powerpoint VBA

  • Thread starter Thread starter Kris Van Baelen
  • Start date Start date
K

Kris Van Baelen

Hi,

In Powerpoint, you can use the Edit, Paste Special menu to
paste for example a link to an Excel chart. Is there a
way to do this programmatically in Powerpoint VBA?

Thanks in advance,

Kris
 
Kris -

One of my PowerPoint counterparts should verify this, but I've been
looking for this feature. To the best of my knowledge, Paste Special
didn't make it into PowerPoint VBA until XP. There's a cottage industry
that has sprung up to provide workarounds.

- Jon
 
Kris,
In addition to Jon's and Glen's comments, another method to to
programmatically,
1. Copy the Excel worksheet to an new Excel workbook and copy the
color palette next if you are using a custom color palette,
2. then copy the chart or range to the clipboard and paste it right
into PPT,

This Excel object will update to the original Excel workbook when ever
it is activated, which can also be done programmatically. It's my
preferred method over the Word method that Glen provides since it is
truly a linked object capable of updating which I don't believe the
Word object is.

Brian Reilly, PowerPoint MVP
 
Back
Top