ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding Picture to Excel Spreadsheet Programatically - Using VB 6 (https://www.excelbanter.com/excel-programming/409035-adding-picture-excel-spreadsheet-programatically-using-vbulletin-6-a.html)

Tushar

Adding Picture to Excel Spreadsheet Programatically - Using VB 6
 
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

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,



All times are GMT +1. The time now is 09:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com