Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
It did not work...
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
It did not work...
Andrew:
Often the easiest way to get the code for something that can be done through the menu commands is to record a macro (ToolsMacroRecord 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 "Andrew" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |