Trying to create a macro in ppt to paste as picture!

H

Heather O'Malley

In PowerPoint I want to copy from Excel and paste as a picture into my slide.
I can record a macro to paste but not as a picture.

Macro:

ActiveWindow.Selection.Unselect

ActiveWindow.View.PasteSpecial

Any ideas? As it does not record when I use the menu bar!
 
D

David M. Marcovitz

Try this:

ActiveWindow.View.PasteSpecial ppPasteMetafilePicture

--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
 
Top