Macro to paste link?

  • Thread starter Thread starter Mel
  • Start date Start date
M

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.
 
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
 
Back
Top