Using VLC plugin from excel / VBA ?

[shodanx]

Hi,

I'm trying to use VLC from excel . I made a VBA application and I would like to show the user video from a usb microscope and allow them to take screenshots of that output.

I have already described my issue in a Stack Overflow thread here
http://stackoverflow.com/questions/3930 ... n-free-com

One confounding issue is that I do not have admin rights on my dev computer so I'm using VLC from a zip file and haven't run the installer.

I added the reference to axvlc.ddl manually.

I also tried registering it using

Code: Select all

regsvr32 axvlc.dll

No matter how I attempt to create the VLC instance I get errors.

For example.

In a module I create the following subroutine

Code: Select all

Sub VLC() Dim myVlC As New AXVLC.VLCPlugin2 myVlC.Visible = True myVlC.playlist.Add (ThisWorkbook.Path & "\demo.mov") myVlC.playlist.Play End Sub

This fails at line

Code: Select all

myVlC.Visible = True

with error

Code: Select all

Run-time error '429': ActiveX component can't create object

I also tried with late-binding

Code: Select all

Sub VLC() Dim actCtx As Object Set actCtx = CreateObject("Microsoft.Windows.ActCtx") actCtx.Manifest = ThisWorkbook.Path & "\vlc\axvlc.dll.manifest" Dim myVlC As Object Set myVlC = actCtx.CreateObject("AXVLC.VLCPlugin2") myVlC.Visible = True myVlC.playlist.Add (ThisWorkbook.Path & "\demo.mov") myVlC.playlist.Play End Sub

This fails on

Code: Select all

Set myVlC = actCtx.CreateObject("AXVLC.VLCPlugin2")

with same error

Code: Select all

Run-time error '429': ActiveX component can't create object

When I try to add the component on the worksheet or on a userform, I simply do not find the VLC object to add at all.

I am quite stuck at this point but please let me know if you have any idea what else to try.

Thanks !

[da2424]

AFAIK, the plugin cannot be registered without administrative privileges.
Does the plugin work with Internet Explorer on the page /sdk/activex/test.html in your vlc directory?
If not, then the dll wasn't registered correctly.

[winops]

Hi , i've used vlc object in my excel vba application
but i need detect it's silence
i means an rtmp is playing ,
signal and pid is ok
but the stream has no sounds !
i need to detect this