Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Call a .pps from excel

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can i call a powerpoint show to open from an excel macro.

    I have tried using
    microsoftappl.xlpowerpoint

    or something similar... but it just opens a new presentation.

    TIA


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sub DisplayWordAutomation()
    Set wordapp = CreateObject("Word.Application")
    'WordApp.Application.Visible = True
    With wordapp
    .Visible = True
    .Activate
    .Run (" type macro name here ")
    .Quit SaveChanges:=wdDoNotSaveChanges
    End With
    End Sub

    Here is a macro I use to open word from excel and then run a word macro. I would just change the word stuff to powerpoint and create a macro in powerpoint to open the file you want and type that macro name in the macro above (no spaces when you type the name). Let me know if it works.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    but if i am simply trying to open a file do i really need to open one application (.ppt) to open another application(.pps)

    there must be an easier way.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am not sure I understand.

    You are trying to open Powerpoint in Excel.

    Or

    Start a Presentation in Powerpoint.

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Qroozn:
    I just wanted to jump in on the issue of *.ppt vs *.pps

    A file that has a pps (powerPoint show extension) will automatically begin to play -- without having to first open the file and then SlideShow|ViewShow

    otherwise a .pps file is the same as .ppt file.

    Regards!

    Yogi Anand

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good Idea Yogi, I did'nt think about that.

    Parra

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I understand that yogi.. thats why i named the file as .pps
    but surely (hopefully) there must be a different way of opening the file then to open ppt application, and call a macro from ppt which then runs the pps file.


  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sorry.. my fault. I will explain a bit clearer.

    I have an excel program. and i also have a powerpointpresentation about the program.
    I want to click on a button in excel and have it run the powerpointshow.

    I hope that is clearer

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    make a hyperlink that will run it

  10. #10
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-06 18:15, brettvba wrote:
    make a hyperlink that will run it
    Yes brettvba! I do it all the time.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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