Is there code for Paste Enhanced Metafile?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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/
 
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
 
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
 
Wow! you guys rock!!
works perfectly!!
thanks!

John Wilson said:
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
Click to expand...
 
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
Click to expand...

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