• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2051
  • Last Modified:

How to use flash object in VBA

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?

  • 2
1 Solution
andy7789Author 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?
Hi andy7789,

There shouldn't be any problem, if there is it would be the code.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now