How can images be inserted in Excel?

I would insert a bmp file in the active cell of an Excel sheet.

I am new to vlax- functions and all I have discovered is
(vlax-invoke-method ActiveSheet "Pictures" "Insert" bmpFile)
but i receive an automation error.

Anyone can help me?

Thanks in advance

Peter

 

I think you can insert the .bmp, but you need
to review 'ActiveCell' - a particular Cell object.
Obtain that object, then try inserting the .bmp.

Bob

 

Thanks Bob,

I can activate the cell where I vant to insert the image, but what I need
is an explanation about the method.
I think I am not passing the right arguments to the vlax-invoke-method
function or even I am using the wrong function.

I know only plain lisp, not VB, and have no experience on using methods.

Peter

 

I have not tried much in EXCEL but you can check what methods and which properties you can change. For this use
(vlax-dump-object <vla-object> t)

this will provide what methods you can do and you can also find how many arguments you require for that.

Nirmal