Images Show On Excel Desktop But Not Excel Online

This is a macro Ive been using to generate an image from a URL in a row's cell. The image is fitted to the first cell in the table. It's been working well however when I try to open the sheet in excel online, the images show as a small white box with a red x in them.
Screen Shot 2017-05-25 at 2.25.02 AM.png

If I go into the sheet and insert the image from a desktop image file they show up in excel online. Wondering how I can fix this so they appear in excel online.

Please Login or Register  to view this content.

Originally Posted by humdingaling

its excel online
you cant insert image on excel online

This is not accurate. I was able to insert an image that shows on excel online. Scenario is if I open an excel sheet in Desktop excel, and then click insert image and select the file from my hard drive, it works on any computer I open that excel online sheet .
Proof: Screen Shot 2017-05-25 at 10.29.24 AM.png

However if I insert the images using the code I listed above, the images only show on the Desktop version of excel and not the online version. This code doesn't pull images from the hard drive like the method I used to get the image to show up. The code takes a URL from a cell on the sheet and then converts it to the actual image on the sheet.

I was hoping someone could look at that code and identify a way to emulate the uploading of an image.

Originally Posted by xlnitwit

Hi,

You need to use Shapes.AddPicture, rather than Pictures.Insert, in order to be able to ensure that the image is embedded and saved with the document.

Thanks this is exactly what I needed. Updates on excel online and desktop. Images sort with the table filters. The offset was because originally I had the image url in a different column and just never took it out. Heres the code I ended up with.

Please Login or Register  to view this content.