Add (non-predifined)Windows Media Player on userform with VBA (button or something)??

Soldinjo

New Member
Joined
Aug 14, 2009
Messages
46
I have an issue with predefined WMP on a userform.
If I put WMP on a userform(define the specs, with, height, stretchTofit = True,...)on one PC and save the file - upon oppening on my bussiness PC&Laptop(part of the domain) I will run into:

Warning about active x controls (that's nothing unusual)
followed by : "System error &H80004005 (-2147467259). Unspecified error"
followed by :"Out of memory"

And the userform in VBA editor is basically out of my reach at that point, if I try to click on it the same error repeats.

The same usually doesn't happen on my personal PC and laptop(not under any domain).

I've noticed that If I remove WMP from the form I can leave all the form buttons (I created) that reference WMP and the problem disappears - file works fine with all PC-s as long as ther'n no WMP on the form, but I have to manually add WMP to the form on each PC&laptop, after opening the file, in order to use WMP on the form(and delete it from the form before saving) in order to avoid the error on another PC.

Is there a way to circumvent this?

I'd like to have a Userform WITHOUT predifined(this seems to be crutial) WMP on it(no WMP can be present on the userform in any shape or form -visible/invisible).
Than, once the form has been initiated - have a button on it that will add(create) WMP on the userform with VBA code instead of manual way.
At that poin the buttons that are referencing non-existant WMP would have something to reference(WindowsMediaPlayer1) in order to play, pause, jump, etc...

Please, help if you can - I'm surprised nobody has mentioned this issue - I'v noticed it on many PC-s for quite some time now.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,224,827
Messages
6,181,197
Members
453,022
Latest member
RobertV1609

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top