How can we insert picture in EXCEL worksheet using Visual Basic 6? I am able
to enter values in the cells. now I want to insert a picture inside
worksheet. kindly help,

Hello,

Sub InsertPicture()
ActiveSheet.Pictures.Insert( _
"C:\Documents and Settings\Hervé Hanuise\My Documents\My
Pictures\!chimneysanta.gif" _
).Select
End Sub

where the fully pathed image file is :
"C:\Documents and Settings\Hervé Hanuise\My Documents\My
Pictures\!chimneysanta.gif"

Hope this helps

--
Herve Hanuise
http://www.affordsol.be


"Tushar" wrote:

How can we insert picture in EXCEL worksheet using Visual Basic 6? I am able
to enter values in the cells. now I want to insert a picture inside
worksheet. kindly help,