troubleshooting Question

Need Assistance Implementing ShockWaveFlash Object in Excel VBA

Avatar of Tony Gardner
Tony GardnerFlag for United States of America asked on
VBAVB ScriptMicrosoft ExcelMicrosoft OfficeMicrosoft Applications
3 Comments1 Solution375 ViewsLast Modified:

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!
Tony Gardner
Sr. Programmer/Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros