asked on 7/23/2008

VBA - Playing Movies using VLC or GOM Player

Hi Folks,

I have a Excel sheet with many files path, this paths refers to Movie files.

I have to create a VBA procedure that when a press a Button appears an inputbox asking the line number of the file (inputbox ("Type the right number",),1) that I want to Play. I have to Use VLC as a player or GOM Player

Can someone help me?

Best Regards

Microsoft Office Microsoft Access Microsoft Excel

Last Comment

Travis Hydzik

7/30/2008

Travis Hydzik

7/25/2008

This solution will work for Windows Media Player, I am assuming it is the same for VLC, just different folder path (which I don't know the names off)

Note: your list of files with have to include the full path and extension.and located in the first row.
Quotes have been placed around the path incase of any spaces.

Sub tester()
 
    'Shell "C:\Program Files\Windows Media Player\wmplayer.exe ""D:\Documents and Settings\e331982\My Documents\Video_Conference.wmv"""
    Dim i As Integer
    i = CInt(InputBox("Type the right number"))
    Shell "C:\Program Files\Windows Media Player\wmplayer.exe """ & Cells(i, 1).Value &""
 
End Sub

Open in new window

mgebste

7/30/2008

ASKER

Thanks it is working properly.

But it is playing on the background, how can I play it full screen:?

Best regards

ASKER CERTIFIED SOLUTION

Travis Hydzik

7/30/2008

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial