Adding Picture to Excel Spreadsheet Programatically - Using VB 6

[Tushar]

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,

 

[affordsol]

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