Need Assistance Implementing ShockWaveFlash Object in Excel VBA
Experts:
I have discovered that I can easily convert my MP4 files into SWF files, and add the ActiveX control to my Excel 2016 XLSM file, but I have a couple of questions I'm hoping can be answered here:
1. I want a separate control to be placed on TOP of the SWF control, and have it be visible and available for use. I read that it is possible to set the ZMode to "Transparent" and that should allow me to accomplish this, but even when playing with the ZOrder property, I'm not having much success in this regard. What's particularly interesting here is shown in the attached example XLSM file. You'll see that if you move the mouse wheel that my command button briefly becomes visible, but once the movement stops, the buttons disappears.
2. I want to be able to SCALE the SWF video to fit inside the frame, and eliminate all white space. Both the original SWF file and its control have a 4:3 display ratio so I'm hoping this is possible. Ultimately, if we can solve Question #1, I would like to have the command buttons be on top of the SWF video and be clickable as well.
Please let me know if there is anything else you need!
ShockWaveFlash-Test.xlsm
SnapIntro.swf
I have discovered that I can easily convert my MP4 files into SWF files, and add the ActiveX control to my Excel 2016 XLSM file, but I have a couple of questions I'm hoping can be answered here:
1. I want a separate control to be placed on TOP of the SWF control, and have it be visible and available for use. I read that it is possible to set the ZMode to "Transparent" and that should allow me to accomplish this, but even when playing with the ZOrder property, I'm not having much success in this regard. What's particularly interesting here is shown in the attached example XLSM file. You'll see that if you move the mouse wheel that my command button briefly becomes visible, but once the movement stops, the buttons disappears.
2. I want to be able to SCALE the SWF video to fit inside the frame, and eliminate all white space. Both the original SWF file and its control have a 4:3 display ratio so I'm hoping this is possible. Ultimately, if we can solve Question #1, I would like to have the command buttons be on top of the SWF video and be clickable as well.
Please let me know if there is anything else you need!
ShockWaveFlash-Test.xlsm
SnapIntro.swf
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Closing question.
ASKER
I'm not sure why this question has not received a single response. Even a simple, "this can't be done" answer would be better than silence.
Nevertheless, I wanted to try to SIMPLIFY my question if the original one cannot be answered.
I went ahead and created a new example XLSM file which has the same SWF file in a UserForm. All I want to do is trigger an event when I click on the running movie. That way, I'll be able to allow the user to stop the movie if they don't want to wait until it completes.
When I requested attention yesterday, I stated that I came up with a work-around solution of placing a screen-shot of the last frame behind the SWF object, and added a 16 second timer loop so I would know to remove the SWF object revealing the image (and button) behind it.
If I am able to detect that the user has clicked on the movie, I can skip the timer and go straight to the static image.
Hopefully, this question has an answer!
SWF-Test-2.xlsm