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

"John Wilson" wrote:

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
--
Amazing PPT Hints, Tips and Tutorials-http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk/ppttipshome.html
email john AT technologytrish.co.uk


"sherobot" wrote:

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

"David M. Marcovitz" wrote:

=?Utf-8?B?c2hlcm9ib3Q=?= wrote in
:

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/