Save charts as image and incrementing file name

Hi all, I know this is a relatively simple one, but just cant think clearly enough today
Basically I am making a macro function to save a copy of a chart as an image file to a specific folder. The chart is a pivot chart and so I am changing the values and saving again after running the macro again, but want the image to be saved with a new file name ie not overwriting the existing one, so ending up with a folder with chartimg1.jpg, chartimg2.jpg, etc..

Below is the code I have after playing around, I know I'm close as i did have it working. It saved the chart jpeg fine, but it just got overwritten when I ran it again to create the net jpeg.

Please Login or Register  to view this content.

Thanks for your reply, I knew it had to be some sort of loop with imcrementing. Have done similar in Java but forgotten it all

Just trying this now but getting a runtime error '13' - type mismatch, on the line 'Set sheetObj = ActiveSheet'. Any ideas?

The active sheet is a tab that contains a pivot chart, but would that not be classed as a worksheet?

Ah I see, it does appear to be a chart sheet. Is there a workaround or can this method not be used?

Thank you, works perfectly!