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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|