VBA Code "Save Graph to Desktop with sequential numbering"

[jdmuc]

Hello dear VBA-specialists,

im an beginner in VBA-programming and came to the point, where i donīt know what to do next. My code is perfectly working when i save a graph (to jpg) to my Desktop. When i try to save anotherone (it is important to know that you can display different data-sets in one single graph with the same Name: e.g. diagramm5) the just saved Chart is overwritten. I can tell that the Problem can be solved by just adding a sequential numbering to the code, but my VBA skills are waaay to low

I hope anyone could help me. Would be great! Thankns in advance!

Here is my code; please donīt be shocked, im just happy that it works somehow

Please Login or Register  to view this content.

Have a nice day,
Jim

[jdmuc]

Good Morning,

i wanted to add an Explanation of what i mean with "add sequential numbering to the code". I would like to make it possible to save lots of Charts with different used data (.jpg) to my Desktop, all made out of one graph (like above e.g. diagramm5). So it would be awesome if the Charts will be automatically numerated when saved. Like: Diagramm5.1, Diagramm5.2, Diagramm5.3 and so on. At the Moment the saved Chart is just called "Diagramm5" and is always overwritten because the next saved Chart has the same Name (Diagramm5).

I would be very grateful for any help or idea! Thank you very much

In another help Forum this code was given me as an solution but i donīt know at which Point i have to insert it into my code, maybe it helps:

Please Login or Register  to view this content.