Hello,
I found the following code that exports charts to a folder but it only it exports one chart even if there is two charts on the same sheet. Can you help please?
ThanksPlease Login or Register to view this content.
Ross
Hello,
I found the following code that exports charts to a folder but it only it exports one chart even if there is two charts on the same sheet. Can you help please?
ThanksPlease Login or Register to view this content.
Ross
Hello
Can you attach sample of your workbook?
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Here you are thanks
it overwrites other charts on the same sheet, because the name is Ws.Name
add for example the chart name to the filename:
Please Login or Register to view this content.
That's because you renamed the chart with the sheet name so the second chart is overwriting the first ..
In this case I put a variable so as to add integer in case of more than one
Please Login or Register to view this content.
only saves CEO & CEO 2 chart and not the rest though now. Thanks
Thanks YasserKhali and SjonR for helping, working now
You're welcome ..
As for SjonR is better in that case ..
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks