Save an Image with VBA

**bibleguy125** · 02-22-2012, 12:30 PM

Hey all,
I am using Excel to make several hundred images and currently have to copy paste the images into paint, then cut it, then paste into a program like paint.NET and save. It has been very tedious so far. Is there any way to simply save a range as a .png, .jpg, or .bmp? I am currently using .png files to call the images into another Excel sheet so that would be preferable. I have this code already:

Please Login or Register  to view this content.

This creates a new chart with the image in it then saves the chart as an image, but the image is of the entire sheet, not just the image selected. I would like to have just the selection become the image if at all possible. Thanks!

**Macdave_19** · 02-22-2012, 12:44 PM

sorry had an idea but decided against it

**AndyPS** · 02-22-2012, 12:48 PM

I have used the following code to export graphs successfully hundreds of times - it writes to a temporary folder (the global variable gsFulTempPath). The graph image is then used in the construction of an email. The other global constant is gsIMAGETYPE which is set to "png". Note the filter.

Please Login or Register  to view this content.

Hope this helps

**bibleguy125** · 02-22-2012, 01:47 PM

I guess I'm not sure how to run that code AndyPS. What specifies the range that it makes into the file?

**royUK** · 02-22-2012, 02:58 PM

This might help

**bibleguy125** · 02-22-2012, 04:39 PM

I don't see how that does anything different than the code I already have. I guess it would work to export a chart as an image, and it's already doing that, it's just that the image is only a part of a large chart. The entire chart exports as an image, so I end up with a bunch of white space. Is there a way to ensure that the chart is exactly the dimensions of a selected image?