We help IT Professionals succeed at work.
Get Started

Need Assistance Implementing ShockWaveFlash Object in Excel VBA

374 Views
Last Modified: 2017-05-25
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
Comment
Watch Question
Sr. Programmer/Analyst
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE