Paste Special in Powerpoint VBA

[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

 

[Jon Peltier]

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

 

[Glen Millar]

Kris,

One vba work-around here:

http://www.powerpointworkbench.com/html/all_vba.html

Paste special from Word.

--
Regards,

Glen Millar
Microsoft PPT MVP
http://www.powerpointworkbench.com/
Please tell us your ppt version, and get back to us here
Remove spaces from signature

 

[Brian Reilly, MS MVP]

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