Macro to paste link?

[Mel]

I'm looking for a macro that will "paste link" whatever is on my
clipboard. More specifically, I copy cells from Excel and in
PowerPoint paste special - paste link. The cells appear in my slide
and update from Excel. I have many such cells to link. Is there some
vba code I can use to do this instead of clicking into the paste
special dialog box? Thanks.

 

[Shyam Pillai]

Mel,
In PPT 2003 and later you can use the pastespecial method to do this.

'Paste link the clipboard
Call
ActivePresentation.Slides(1).Shapes.PasteSpecial(ppPasteOLEObject,false,false,false,false,true)

Regards,
Shyam Pillai

Animation Carbon
http://www.animationcarbon.com

 

[Mel]

Thank you ever so much. That will make my task a lot easier if I go
this route.

-Mel