It did not work...

[Guest]

Hi, Galimi,

I used the following VB code:

Dim exl As Excel.Application
Set exl = New Excel.Application
exl.Visible = True
exl.Workbooks.Open ("c:\temp.xls")
exl.ActiveSheet.Picture.Insert ("c:\zi.bmp")

on the last line I got error 436: Object does not support this propery of
method.

???

thanks.

 

[Ed]

Andrew:

Often the easiest way to get the code for something that can be done through
the menu commands is to record a macro (Tools>>Macro>>Record New Macro). I
recorded a macro for inserting a picture and came up with
ActiveSheet.Pictures.Insert( _
"C:\FilePath\FileName.jpg"). _
Select

(FilePath and FileName would, of course, be replaced with the actual path to
and name of the picture file you want to insert.)

If you got the code you used from the VBA Help file, my applause for using
Help - but I caution you to also check the Applies to. Picture (no "s", as
opposed to Picture"s" as in my macro) applies to UserForms and controls
mostly.

HTH
Ed