Consulting

Results 1 to 4 of 4

Thread: find and replaceall macro for powerpoint

  1. #1

    find and replaceall macro for powerpoint

    Help me please...

    I am trying to program my first ever macro in powerpoint 2003/2007. I don't think what I want to do is complicated and could really do with a finished bit of working code to paste into visual basic. I am a novice and the help pages and many hours of scouring the internet has come to no answer.

    I want the macro to find the text "qu1" which is featured 17 times in the presentation and replace it with text entered from a dialogue box. The macro will need to do a bit more than this eventually but I should be able to figure out how to do the rest.

    Cheers for any help,

    John

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,724
    Location
    PP's object model doesn't expose it's built-in dialog boxes the way Excel and Word do. The best you can do usually is to use SendKeys to invoke the dialog in the open window. So this might be a more flexible way to do what you want

    Paul

    [VBA]
    Sub MyReplace()
    Call SendKeys("^h")
    End Sub
    [/VBA]

  3. #3
    VBAX Mentor Brandtrock's Avatar
    Joined
    Jun 2004
    Location
    Titonka, IA
    Posts
    399
    Location
    Cross posted and solved HERE.

    Thanks for your input Paul.

    Regards,
    Brandtrock




  4. #4
    VBAX Regular
    Joined
    Apr 2007
    Posts
    8
    Location
    Hi
    Does the attached help? Text entered at runtime is stored in a textbox on the slide and a command button then runs a macro to replace qu1 with this text!
    lion

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •