Transfer Macros Word to PowerPoint.

[Robert]

Hello Everyone,
My problem stems from the need to use Foreign Language (FL) characters
borrowed from the Symbol font. I have produced eight short macros for
them, here is one:

Sub M2()
' Prints Schwa, Symbol hex 0259

Selection.InsertSymbol Font:="Arial", CharacterNumber:=601, _
Unicode:=msoTrue
End Sub

These work well in Word where they can be called by keyboard shortcuts.

I need however to transfer them to PowerPoint where they were
originally intended. Surprisingly I found that before such a transfer
they were still available to PowerPoint from Word. But I will soon
travel abroad and need to take my PPT presentations with me.

So how can I transfer them (and modifiy them if needed?) to PowerPoint?
I have tried Copy/Paste but the Clipboard corrupts some of the macros,
and after I have edited them, PPT shuts down and the macros disappear.
What am I doing wrong, please?

One final little point, when run these macros leave the FL character
highlighted. What must I add to remove this?

Thank you for any help.

Robert.

 

[Jean-Guy Marcil]

Robert was telling us:
Robert nous racontait que :

Hello Everyone,
My problem stems from the need to use Foreign Language (FL) characters
borrowed from the Symbol font. I have produced eight short macros for
them, here is one:

Sub M2()
' Prints Schwa, Symbol hex 0259

Selection.InsertSymbol Font:="Arial", CharacterNumber:=601, _
Unicode:=msoTrue
End Sub

These work well in Word where they can be called by keyboard
shortcuts.

I need however to transfer them to PowerPoint where they were
originally intended. Surprisingly I found that before such a transfer
they were still available to PowerPoint from Word. But I will soon
travel abroad and need to take my PPT presentations with me.

So how can I transfer them (and modifiy them if needed?) to
PowerPoint? I have tried Copy/Paste but the Clipboard corrupts some
of the macros, and after I have edited them, PPT shuts down and the
macros disappear. What am I doing wrong, please?

One final little point, when run these macros leave the FL character
highlighted. What must I add to remove this?

For the transfer to PowerPoint you should post this in a PowerPoint group.
Macros and custom toolbars are managed very differently in PowerPoint. I
have dabbled in it, but you would be better served with the experts in the
PPT group. One thing is for sure is that you cannot just copy/paste a VBA
macro from one application to another and expect it to work. The underlying
Object model is totally different. A VBA key word, property or method in
Word may not exist in PowerPoint, or it may have a totally different
meaning/usage.

As for your last question, try adding this at the end of the macro:

Selection.Collapse wdCollapseEnd




--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Robert]

Merci Jean-Guy de votre contribution au forum. I'm beginning to
understand just how different the two object models really are. Thanks
also for the bit of code. Although it removes the selection in Word,
it does not do so in Powerpoint. Les recherches continuent!

I tried to write this post in French, but such is the genius of Google
(whose system I use to manage Newsgroups) that all the accented
characters and those either side of them became completely garbled and
unreadable. Is this progress??

Thanks again.

Robert