vba code to export image file, preferably jpg

[daveus]

Hi all,

I searched and didn't find anything related to this.

I would like vba code that will export a given group of cells, or a defined print page area to a jpg file (preferable, but other image format would work). I'm planning to create a program that will change some cell data and create a jpg file for various sets of data. I suppose if that's not possible that another alternative would be ok, so i'm open to suggestions, but the export to jpg format would be great. I found a little program that will do it, but i wanted to include the code in my program to make it all automated.

Any help is greatly appreciated. Thanks all!

David

 

[mark hansen]

Sorry, I realize this is an old thread. An internet search for this subject brought to this thread. I tried the code from Jaafar and on two PCs (one at work and one at home) the following line caused Excel to shut down and reboot. Am I missing something?

OleCreatePictureIndirect uPicinfo, IID_IDispatch, True, IPic

It does copy the image to clipboard AEB pasting in PowerPoint, but I can't get it to save a BMP. I would love to be able to use an Add On, but I can. Any advise is appreciated.

Mark