Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paste Special in Powerpoint VBA? 2

Status
Not open for further replies.

johnnygeo

Programmer
Apr 23, 2003
125
US
I'm trying to write a macro in PowerPoint to perform a Paste Special ... Paste as Picture action.

In Excel it works using ActiveSheet.PasteSpecial. But the VB library for Powerpoint doesn't seem to have this method at all.

Is there a workaround?

Thanks,
Johnny Geo
 
johnnygeo,

The PasteSpecial method is available in PowerPoint thru the 2003 version; I'm not sure if it still exists in 2007. Which version are you currently using?


[glasses]

----------------------------------------------------------------------------------
"A committee is a life form with six or more legs and no brain." -- L. Long
 
Powerpoint 2007 certainly does have PasteSpecial. Something like the following, for example:

Public Sub Example()
Application.ActiveWindow.View.PasteSpecial ppPasteBitmap
End Sub
 

I haven't had 2000 on a computer for some time, but I'm pretty sure that PasteSpeciel was there. Have you opened the code page and type "paste special" into Help?

[glasses]

----------------------------------------------------------------------------------
"A committee is a life form with six or more legs and no brain." -- L. Long
 
strongm,

Really valuable information for a lot of people. Have a purple pointy-thing ==> [purple]*[/purple] on me!

[thumbsup2]

----------------------------------------------------------------------------------
"A committee is a life form with six or more legs and no brain." -- L. Long
 
Wow, that is ugly. But it will still probably save me a bunch of time. Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top