placing a bitmap on a xls file. 1

[kingz2000]

Hi,

how can I place a bitmap (C:\xyz.bmp) on a particular field ,[H3] say, in a particular excel file (C:\test.xls)

Thanks in advance!

 

[rmikesmith]

Something like the following will place the bitmap with its upper left corner in cell H3:

Sub InsertBitmap()
Dim Wkb As Workbook

   Set Wkb = Workbooks.Open("C:\test.xls")
   
   With Wkb.ActiveSheet
     .Cells(3, 8).Select
     .Pictures.Insert ("C:\xyz.bmp")
   End With
   Wkb.Close SaveChanges:=True
   
End Sub

Regards,
Mike