Thread: Adding Picture to Excel Spreadsheet Programatically - Using VB 6
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
affordsol affordsol is offline
external usenet poster
  
Posts: 29
Default Adding Picture to Excel Spreadsheet Programatically - Using VB 6
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,
Reply With QuoteReply With Quote