vba - Export cell range to image on desktop! Help with code

Hi all,

What I am trying to do is relatively simple but requires a fair bit of code from what I understand... I am trying to simply have a macro that exports a constant cell range (i.e. A1:C10) to an image file on the desktop. PNG is fine. But the image must be of decent quality. Which all the solutions for this problem result in the chart method, where the code creates a chart from cells and then exports that chart. The quality is sacraficed. The other method is using the print page function.

I found the best code I could, I like all the added features, such as msg box, desktop file path of CURRENT user, and a file name prompt. But it requires you to manually select the cells. Not to mention, it does not work!

Can someone write similar code for me that achieves this?

HERE IS SOURCE: https://stackoverflow.com/questions/...-in-excel-2003

Code:

Please Login or Register  to view this content.

Thank you

Hi all, thanks for the replies. Much Appreciated.

I decided to first try Kaper's method. It seems I was only missing the activate.chart call. I then used Kaper's suggestion to remove the selection objects and replace with a range.

The resulting code is as follows:

Please Login or Register  to view this content.

Thank you very much!!!

Hi all,
back again with another question...

Is there anyway I can have an OVERWRITE warning with this code? I will have multiple macros with this code, which the user can export an image for different parts of the spreadsheet. However, assume the user is lazy (which is how we all are, lets admit it), and chooses to not change the file name, the exported file is overwritten without warning. Any way to implement this or is this diving to much into windows to be possible?

Thanks