Save Chart as jpg in a defined path

Hi there,

I do not know much about VBA programming. Nevertheless I have 4 tabs (Sheet 1, Sheet 2, Sheet 3 and Sheet 4) in which there is one Chart in each. I want them to be converted into jpgs via one Button which is on a Separate Sheet. The jpgs should then be saved on my desktop as Sheet1.jpg, Sheet2.jpg, Sheet3.jpg and Sheet4.jpg.

Can you please help me find the right VBA code to have this accomplished.

Many thanks in advance.

Since I did this before AlphaFrog's post, adjust as needed.

Please Login or Register  to view this content.

Sorry for the late reply.

Both codes work absolutely fine.

What do I have to change to uplode the picture onto a virtual server? "SpecialFolders("path name")" doesnt seem to cut it.

Thanks in advance.

AlphaFrog, amazing!

I have one more issue. I need it in a much higher resolution. something along the line of 1080p.

Is that possible?

Unfortunately, this does not work. See attached file.

You will need to know the height as well. See if this helps. https://www.reddit.com/r/excel/comme...w_to_export_a/

Hi Kenneth,

Thanks for the link. Good read. How can I implement this into the code above.

Sorry to be a pain but I really have no clue about VBA.

Thanks in advance.