Accessing Flash Controls and Images using Excel Macros

[rahulwagh]

Hi,
In my project to create a daily report user login to the website which is developed in HTML and flash.
On the website they select the date range and based on that graphs are generated after that they takes a screen shot of it (using print screen) and after that they does some formatting in paint and they add the formatted screen on PPT.
Selection on date from date control and the graph all in adobe flash.
Now I want to convert this manual process into automated process by writing some excel macros.
Could you please suggest hoe to do it?

Thanks in advance!!!

[zmbd]

If possible, this would require an extensive understanding of VBA. For beggining programmer, or even the novice, this simply isn't possible.

If you'd like a little taste of the difficulties that even very experienced programmers are facing with this do a search on the internet for "VBA Flash Interact" keywords. There simply isn't an easy method to even get information into the Flash objects and trying to return information doesn't seem possible.

As for the editing of the graph, this is a human thing, you're not going to be able to automate that...

Inserting the file, unless the file name of the image is goig to be the same, never changing, then this is also a human thing that is not autamatable.