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

How to Import Formatted text as new Slides in PowerPoint 0
Select Text to End of Footnote 9
How to display the merge function "url" of a picture? 0
Embed the same Excel multiple times 0
Menu Macro Not Executing - Need Help 1
Change a great number of words in word files, with a macro as short as possible. 5
Create a dynamic master file 1
Need Help with Macro Security 1

Top