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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste special problem 2
Editing Pictures in ppt 1
Simple PowerPoint macro hangs on apparent bug 11
vba powerpoint pasting named shape in selected named slides 0
pastespecial in powerpoint 2010 vba 0
Create Individual Slides from a PPT Deck 0
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Macro to paste link? 2

Top