Consulting

Results 1 to 3 of 3

Thread: Presentation in UserForm

  1. #1
    VBAX Regular
    Joined
    Aug 2007
    Posts
    16
    Location

    Presentation in UserForm

    Hi guys,

    Do you know how to play a .pps(PowerPoint Slideshow) File in a UserForm. Is there any tool for that?

    10x
    metev

  2. #2
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    Quote Originally Posted by metev
    Hi guys,

    Do you know how to play a .pps(PowerPoint Slideshow) File in a UserForm. Is there any tool for that?

    10x
    metev
    an interesting question ... why do you wish to play it IN the UserForm? I would think that the reduction in display size would be a disadvantage. Would it be acceptable to have a button on the userform which when clicked fires up the PowerPoint Slideshow? If so, this could be done using a simple hyperlink approach. In the example below, the file is a pdf and the result is Adobe Acrobate starting up and displaying the pdf file; but the method works for any file type.

    Private Sub cmdbtnShowFile_Click() 
    Dim strAddress As String 
    On Error Goto NoFile 
        strAddress = "D:\test.pdf" 
        ActiveWorkbook.FollowHyperlink Address:=strAddress 
        Exit Sub 
    NoFile: 
        MsgBox "Sorry.  File is not available at this time", vbInformation, "MA Tools Utilities" 
    End Sub
    I use this approach a lot in UserForms to display help files. It is very easy to implement and bypasses shell stuff and considerations re the correct application to start and its location.

    When the number of different files that could be displayed is greater than "a few", multiple buttons gets messy, so I either have a single button that hyperlinks to a file where additional hyperlinks reside for the various possible targets or have a list box in the UserForm that contains the various possible targets. When a target is selected from the list box, the background code builds the appropriate hyperlink and the relevant target file is displayed.

    Hope this helps
    Last edited by Aussiebear; 04-28-2023 at 08:12 PM. Reason: Adjusted the code tags
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

  3. #3
    VBAX Regular
    Joined
    Aug 2007
    Posts
    16
    Location
    10x,

    have you ever used the webbrowser control?
    Because I read in a forum that I can save my .pps file as a WebPage a then show it in my UF.

    your solution works fine!!
    10x once again

Posting Permissions

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