Help! Adding ShockwaveFlash Controls Broke My Excel File! How to Recover???
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