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?