ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inserting Picture Excel Sheet (https://www.excelbanter.com/excel-programming/288663-inserting-picture-excel-sheet.html)

Ussiddiqui

Inserting Picture Excel Sheet
 
Hi dudes !

Today i tried to insert picture in Excel Workbook, from VB , Actually i
dont know the exact funciton to do it , Telling you people , Who would
like to help me, if they already dont know that there is a function
available to insert the picture/logo on background of the excel sheet.
But i want to know the function to Insert the picture in to any
specific column or at any postion,

I will be very greatfull for the expert that will tell me this
problem's solution this night :-)


---
Message posted from http://www.ExcelForum.com/


Ron de Bruin

Inserting Picture Excel Sheet
 
Try this example that place the picture in cell c1

Sub test()
Dim YourPic As Picture
With ActiveSheet.Range("c1")
Set YourPic = .Parent.Pictures.Insert("C:\Data\Picture 015.jpg")
YourPic.Top = .Top
YourPic.Width = .Width
YourPic.Height = .Height
YourPic.Left = .Left
End With
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Ussiddiqui " wrote in message ...
Hi dudes !

Today i tried to insert picture in Excel Workbook, from VB , Actually i
dont know the exact funciton to do it , Telling you people , Who would
like to help me, if they already dont know that there is a function
available to insert the picture/logo on background of the excel sheet.
But i want to know the function to Insert the picture in to any
specific column or at any postion,

I will be very greatfull for the expert that will tell me this
problem's solution this night :-)


---
Message posted from http://www.ExcelForum.com/




Ussiddiqui[_2_]

Inserting Picture Excel Sheet
 
Hay who every you are ... you saved my deliverable ......
thanxxxxxxxxxxxxxxxxxxx Allotttttttt , message to Rena..........

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 08:02 PM.

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