troubleshooting Question

Help! Adding ShockwaveFlash Controls Broke My Excel File! How to Recover???

Avatar of Tony Gardner
Tony GardnerFlag for United States of America asked on
* ShockWaveFlashMicrosoft ExcelMicrosoft Visual StudioVBA* Debugger
5 Comments1 Solution138 ViewsLast Modified:
Experts:
I appear to have broken my Excel XLSM file by adding a UserForm with the ShockWaveFlash control on it. The first sheet originally had the SWF ActiveX control added, but I found that putting the SWF control in a UserForm makes it fill the screen (scaling) better. So, I created a new UserForm called frmSnapIntro and added the SWF control with the path to my SWF file. I then deleted the control on the first sheet, and added some code to ActiveWorkbook_Initialize so it would load and show frmSnapIntro, wait 16 seconds, then hide the form. In each step, I made sure the SWF would play using my code, and it all looked good. Finally, I saved it overwriting my original file. Much to my horror, when I re-opened the XLSM file, Excel crashed with the attached error. I do have a backup on my Dropbox account that is about three days old, so I'm not completely lost, but I would REALLY like to find a way to recover the file if at all possible.

I would also like to note that I tried renaming the SWF file on my local hard drive in the hopes that the script would fail and go to debugger, and strangely, it didn't crash right away, but displayed an empty UserForm, waited 16 seconds and THEN crashed. I even tried exiting the form, and clicking several other things during the 16 second period, but in each case, it immediately crashes.

I also checked to see if I have Previous Versions enabled, and it is not. I will talk with my I.T. Manager to see if he can help me get that setup for future disasters.

In regards to the error, please note that I do have Visual Studio 2013 and Excel 2016, so I was able to at least launch VS in debugger mode and see the interface. I just don't know what to do.
SWF-Crash.pdf
ASKER CERTIFIED SOLUTION
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 5 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 5 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