Quote Originally Posted by Charlize
The original coding in this file was from Stephen Bullen. He used a form with a picture object on it. The picture object was filled with the data on the clipboard. Anyway, I've written a routine that uses his functions to deal with a picture on the clipboard. The routine will allow you to select the destination where you want to save your picture (bmp file) and you may choose your name. If no picturedata is present, you will be informed.

Just press printscreen, select the workbook with this routine and run the routine save_a_picture.

Hope you'll like this one.

Charlize
New to this board so I may have not replied correctly.

Please email me a copy of your modified code bit as I'm trying to do the same thing or if there is a way to do this in Excel 2010, let me know. Thanks,