We help IT Professionals succeed at work.

How to use flash object in VBA

2,315 Views
Last Modified: 2013-11-26
Hi x-perts,

I need to incorporate interactive charts in VBA and am thinking about flash objects. as far as I know there is only a Shockwave Flash Object My questions:

1) How can I pass variables from flash to VBA userform and back? I could pass the info as a generated XML file from VBA to flash, but don't know how to do it on-the-fly. Can I pass flashvars somehow?

2) are there any other active-X libraries for this purpose (interactive graphics and charts)?

3) Is there a way of bridging Action script and VBA?

Thanks
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you! Very helpful!

All the referfences are for VB and #C. should I experience any problems with VBA For excel)?

I believe, as soon as I connect Shockwave Flash Object, it should be the same. Correct?
H01

Commented:
Hi andy7789,

There shouldn't be any problem, if there is it would be the code.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.