Help with Chart to PNG export macro needed.

Hi all,

first please let say that I am new to VBA, but have some basic knowledge about macros so apologies in advance if I will be asking silly questions or using incorrect terms.

Now, I am working on a macro that will export all charts from two specific worksheets called "YTD Graphs" and "MTD Graphs"
I was able to put together macro below, but it exports charts only from "MTD Charts" sheet (Chart Tools displayed on top of the workbook when "MTD Graphs" sheets is active).

Both sheets have 9 graphs in them that need to be exported. For now graphs are being exported into file source folder. Later I would like to add prompt for users to select path or subfolder.

So at the moment only "MTD Graphs" are being exported and I can't make the "YTD Graphs" to work.

Unfortunately I can't attach the Workbook for you to have a look due to data sensitivity.

Please Login or Register  to view this content.

I was thinking about using

Please Login or Register  to view this content.

to directly set sheets that I want the macro work with or at least somehow activate "YTD Graphs" sheet.

Thanks in advance for your help.

Tom

Hi romperstomer,

thank you for your reply.

The code doesn't trigger eny error at all.

Our report file has some 20-ish Worksheets and charts that I need to export are in Worksheets called "YTD Graphs" and "MTD Graphs". I wanted to make sure that if there would be any other charts in the rest of the Worksheets that they get exported too.

Idea was that first part of the code exports all charts that are in their own sheets and the second part of the code should export charts that are embedded inside normal sheets.

When it comes to refixes, I intended to save charts from "YTD Graphs" worksheet with "YTD" prefix and charts from "MTD Graphs" with "MTD" prefix to distinquish them.

Tom

Good point! I was so focused if I did the coding right and was thinking that something is wrong with it that I completely overlooked this aspect.

The charts in the "YTD" were not in fact charts, but images. That explains why I did not get any errors and no exports from that sheet either.

So thank you romperstomper for pointing that out to me!

I now got updated file from analysts and both "YTD" and "MTD" sheets now contain charts that are being exported properly.

I am feeling silly for not double checking such basic thing.

Now I have to ensure that exported PNGs have refix of the Worksheet that they were exported from and implement dialog box asking users to select path to save the images.

Do you guys have an idea how to do something effective in my macro? Any help is very appreciated.

Thank you.

Tom