Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Call a .pps from excel

  1. #11
    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

    as far as code is concerned

    i found this but I don't know what its for
    .msoConditionFileTypePowerPointPresentations
    that might have something remotely to do with it??

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

    Default


    Thanks for the hyperlink idea.

    the code i now have is
    'j1 has got the hyperlink address'

    Range("J1").Select
    Selection.Hyperlinks(1).Follow window:=False, AddHistory:=True
    Application.WindowState = xlMaximized

    the problem is that is using the web toolbar.
    and i am seeing all the powerpoint toolbars instead of a full screen(as compared to when you normally run a .pps file.)

    this will surfice for now. thanks for everyones assistance. But i never say no too more guidance. A little bit of knowledge is a dangerous thing.

  3. #13
    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

    is there code to maximise the window
    goto browse/fullscreen


  4. #14
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you must run via code then
    Set a reference to the powerpoint obl

    Code;


    Sub Run_PPS()

    Dim ppApp As PowerPoint.Presentation

    Set ppApp = GetObject("C:Program FilesMicrosoft OfficeOffice1033Overview.pps")
    ppApp.SlideShowSettings.Run

    End Sub


    Kind Regards,
    Ivan F Moala From the City of Sails

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
  •