Consulting

Results 1 to 4 of 4

Thread: How to Check if PowerPoint Object is Open; If so, do not Open another and Use Opened

  1. #1
    VBAX Regular
    Joined
    Apr 2018
    Posts
    6
    Location

    How to Check if PowerPoint Object is Open; If so, do not Open another and Use Opened

    Code below opens a new PowerPoint. However I need to first check if the powerpoint is already opened (in case this logic has ran before some place else), and if so, simply append to the powerpoint (instead of creating a new one every time). Thoughts?

    Dim objPPT as Object
    objPPT.Presentations.Open ThisWorkbook.Path & "\Test.ppt"
    I'm using Excel 2010 if that helps. Thanks

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    Are you checking if Powerpoint is open or that file test.ppt is open?
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  3. #3
    VBAX Regular
    Joined
    Apr 2018
    Posts
    6
    Location
    Would need to check if Test.ppt is open. If it is, not to open another one, and simply add to it...

  4. #4
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    Assuming that PowerPoint is open loop through all the open presentations and check for the name test.pptx
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

Posting Permissions

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