How do I insert a WebP-image jpg in Excel using VBA

Question

I'm working with an online WebP image. Despite being a WebP image, the file name ends in.jpg.

I want to use the "ActiveSheet.Pictures.Insert" command to insert this picture into an excel sheet. My code operates flawlessly on real.jpg images, but it fails to operate on this image. It's only possible that it's a WebP image, in my opinion (I got error code 1004: "Unable to get the Insert property of the Pictures class").

Is there a way to handle WebP photos in Excel or VBA? I tried to research FreeImage, but I have no experience with any of this. If I understand well, how can I change an image using FreeImage as a plug-in?

Answer 1

It's not currently on the list of supported types:

https://learn.microsoft.com/en-us/deployoffice/compat/office-file-format-reference

I recommend you convert the image to JPG or BMP format before you insert the image.