Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.
Nice raj
Much appreciated.