Re: Embedding Image in Excell

Also see Using Win32::OLE and Excel - Tips and Tricks, and my reply there on how to use the Macro Recorder to find out what you need to do to actually embed the image instead of linking to it.

Comment on Re: Embedding Image in Excell

Replies are listed 'Best First'.
Re^2: Embedding Image in Excell by merrymonk (Hermit) on Feb 16, 2011 at 16:58 UTC
I recorded an Excel macro to embed an image and got the following `ActiveSheet.OLEObjects.Add(Filename:="C:\aaaaa\700 plate selection.jpg +", _ Link:=False, DisplayAsIcon:=False).Select` [download] However, I found a difference when I ran this macro on 2 PCs. On the 1st PC all was well and I could see the image. On the 2nd PC all I got was a rectangle with the name of the image in the rectangle. I could see the image when I double clicked on the rectangle. I am not aware of any settings for Excel that gives this difference. What do I do to ensure that I always see the image as I found on the 1st PC P.S. I have not yet started to convert the macro to Perl. If anyone has the time to help I would appreciate it as I suspect I am going to have problems!	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Embedding Image in Excell
by merrymonk (Hermit) on Feb 16, 2011 at 16:58 UTC

ActiveSheet.OLEObjects.Add(Filename:="C:\aaaaa\700 plate selection.jpg
+", _
        Link:=False, DisplayAsIcon:=False).Select
[download]

[reply]
[d/l]