Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an Excel application that creates 12 PPT slides and pastes data from Excel. I want to force PowerPoint to always be the active application (in the topmost window), however I find it works differently if PPT is already open. I have code like this:

    objPPT.Visible = True
    objPPT.Activate

    But this doesn't do anything if PPT is already open (but not topmost window). How can I force PPT to always be active (visible) on top of Excel? I want the user to see that their PPT slides are ready and not have them click the status bar to see it.

    Thanks, Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try this instruction:

    AppActivate "Microsoft PowerPoint"

    If PowerPoint is running and visible, this will bring it to the front. (It looks for a window whose title starts with "Microsoft PowerPoint")

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='768405' date='30-Mar-2009 23:16']Try this instruction:

    AppActivate "Microsoft PowerPoint"

    If PowerPoint is running and visible, this will bring it to the front. (It looks for a window whose title starts with "Microsoft PowerPoint")[/quote]

    Excellent, that worked for both instances (if PPT was already open when the code ran, or not).

    Thank you, Deb

Posting Permissions

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