A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is there code for Paste Enhanced Metafile?



 
 
Thread Tools Display Modes
  #1  
Old March 13th, 2007, 04:22 PM posted to microsoft.public.powerpoint
sherobot
external usenet poster
 
Posts: 49
Default Is there code for Paste Enhanced Metafile?

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

  #2  
Old March 13th, 2007, 04:30 PM posted to microsoft.public.powerpoint
David M. Marcovitz
external usenet poster
 
Posts: 1,267
Default Is there code for Paste Enhanced Metafile?

=?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/
  #3  
Old March 13th, 2007, 05:05 PM posted to microsoft.public.powerpoint
sherobot
external usenet poster
 
Posts: 49
Default Is there code for Paste Enhanced Metafile?

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/

  #4  
Old March 13th, 2007, 05:41 PM posted to microsoft.public.powerpoint
John Wilson
external usenet poster
 
Posts: 6,023
Default Is there code for Paste Enhanced Metafile?

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/

  #5  
Old March 13th, 2007, 06:03 PM posted to microsoft.public.powerpoint
sherobot
external usenet poster
 
Posts: 49
Default Is there code for Paste Enhanced Metafile?

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/

  #6  
Old March 13th, 2007, 06:44 PM posted to microsoft.public.powerpoint
David M. Marcovitz
external usenet poster
 
Posts: 1,267
Default Is there code for Paste Enhanced Metafile?

=?Utf-8?B?Sm9obiBXaWxzb24=?= john AT technologytrish.co DOT uk wrote in
:

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/
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.