View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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/