Embed SWF into excel and change it flashvars when excel file is loaded
- by Fraga
Hi.
I have a ShockwaveFlash embeded in excel.
This SWF need 1 dynamic flashvar to run.
I need to set it just before flash file is loaded, so flash can run without problems.
Something like this.
Private Sub Worksheet_Activate()
ShockwaveFlash1.FlashVars = "DynamicData=123"
ShockwaveFlash1.Play
End Sub
But it doesnt work.
Ideas?
PD: Macros was my first idea, any other solution could be better.