Is there code for Paste Enhanced Metafile?

[sherobot]

I have tried and failed to record a macro that performs the function of
Edit/Paste Special/Enhanced Metafile picture. My recorded macros come up as
empty 'subs'. Can I get around this limitation with VBA code? I can't seem
to...help. Thanks. Same question as another guy, but I do have 2003

 

[David M. Marcovitz]

I have tried and failed to record a macro that performs the function
of Edit/Paste Special/Enhanced Metafile picture. My recorded macros
come up as empty 'subs'. Can I get around this limitation with VBA
code? I can't seem to...help. Thanks. Same question as another guy,
but I do have 2003

ActiveWindow.Selection.SlideRange(1).Shapes _
..PasteSpecial ppPasteEnhancedMetafile

--
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/

 

[sherobot]

It's saying invalid use of property for the "shapes" text. and it didn't
recognize
ppPasteEnhancedMetafile. Can you elaborate more on the how to put in the
coding?
I'm just not that good with it yet.
I am trying to copy a table from Excel and paste it into powerpoint as an
enhanced metafile picture.
Thanks

 

[John Wilson]

There's a small typo it should be

ActiveWindow.Selection.SlideRange(1).Shapes _
..PasteSpecial ppPasteEnhancedMetafile
(only one dot before paste special)

There are some vba tutorials on Powerpoint Alchemy and also lots at
http://www.pptfaq.com

 

[sherobot]

Wow! you guys rock!!
works perfectly!!
thanks!

There's a small typo it should be

ActiveWindow.Selection.SlideRange(1).Shapes _
.PasteSpecial ppPasteEnhancedMetafile
(only one dot before paste special)

There are some vba tutorials on Powerpoint Alchemy and also lots at
http://www.pptfaq.com

 

[David M. Marcovitz]

There's a small typo it should be

ActiveWindow.Selection.SlideRange(1).Shapes _
.PasteSpecial ppPasteEnhancedMetafile
(only one dot before paste special)

There are some vba tutorials on Powerpoint Alchemy and also lots at
http://www.pptfaq.com

Oops. I had cut and pasted the code, but I tried to adjust the line breaks
in the newsreader. I thought that would be simple enough to do, but I
managed to mess that up. Thanks for catching that.
--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/