Exporting objects in Containers

[sangland2]

Hi, I have 2 charts and one table which I can export to Excel using a Macro from a button. When move them to a container and remove them from outside the container then I get an error from the macro. After some testing I have concluded than only 1 chart inside a container can be accessed by a Macro (does't matter which one). Does this make any sense? I can add tables to the container and these can be accessed by the macro.

[jagan]

Hi,

Check this links

How to use macros to export objects into excel

Re: Export multiple Container into Excel

Export chart from container by macro

Regards,

Jagan.

[tamilarasu · Accepted solution]

Hi Simon

I too faced this situation once and found a solution. Hope the below attachment helps you.

Go to macro window and update the below part as per your requirement..

If you have any issues, let me know.

Update: I just removed some lines of code (as I found not necessary) and attached a new application.

[Chanty4u]

Nice raj

[sangland2]

Much appreciated.