Embed SWF into excel and change it flashvars when excel file is loaded

Posted by Fraga on Stack Overflow See other posts from Stack Overflow or by Fraga
Published on 2010-05-26T02:39:18Z Indexed on 2010/05/26 2:41 UTC
Read the original article Hit count: 410

Filed under:
|
|
|

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.

© Stack Overflow or respective owner

Related posts about flash

Related posts about excel