Export charts from container to excel Macro

[tamilarasu]

Hello All,

I am trying to export three charts in a container into single excel file. I tried the below attached code, but its not working as expected. When I click the button, it just exporting the first chart (that too when the chart is active). Could someone provide me the code against attached QVW file.?

Thank you.

[tamilarasu]

Sorry. Wrong attachment. Correct file attached now.

[#3]

[tamilarasu · Accepted solution]

All,

After lot of bugs, I have modified the code completely and got what I expected. Check the below attachment. Hope this helps someone someday. !

to All.