Copy/Paste a range as a bitmap

[DavidVee]

I would like to be able to copy a range of cells and paste to an outlook email as a bitmap via VBA. I have been able to do this as a normal paste but I would like to retain the formatting from excel and this seems to be the only way to do it. Is this possible in a macro??

Thanks
This message was edited by DavidVee on 2002-09-23 15:53

 

[Jay Petrulis]

Hi,

Stephen Bullen has code to do what you want.

http://www.bmsltd.co.uk

In Stephen's Excel section there is a zipped file called "PastePicture" which will allow you to save as a bitmap.

 

[Ivan F Moala]

Colo's cool addin has this functionality in it...code was supplied by DK...
have a look @ the bottom of this screen for the address

http://www.interq.or.jp/sun/puremis/colo/HtmlMaker.htm

 

[royUK]

Another free download has this fuction - http://www.asap-utilities.com
This message was edited by royUK on 2002-09-23 22:55

 

[DavidVee]

Thanks to all those who responded. I will check out the links you provided. Ill let you know how they work.

Thx!!!!!!

 

[DavidVee]

I found this on one of the posted links this bit of code which gives me the desired result:
Selection.Copy
ActiveSheet.Pictures.Paste Link:=True).Select