Display image from URL in a UserForm without downloading into local drive

Hello,

I have a userform with an image1 object. I'd like to insert an image into that image object directly from a url address (e.g. http://upload.wikimedia.org/wikipedi...013_Google.png). I'd like to do this without the need to download the image file into my default C: drive if possible.

I've researched this on the web and have come across a few threads, but none seem to work as described by the OP as listed below:


http://www.experts-exchange.com/Soft....html#view-all

http://www.excelforum.com/excel-prog...ml#post3942354

http://www.excelforum.com/excel-prog...-userform.html


Thanks,

Noel

Obviously, you can not use the method posted in the last link for an Image object. If you are going to use that method, use the WebBrowser control as they did.

I did a userform with their image and yours. In the VBE, be sure to set a reference in Tools > References to the Microsoft Internet Controls, if it shows missing in the attached file. I also did some tweaks to the code. I wanted the control to resize to the image size. Of course that is the advantage of downloading images, you can easily find the size and makes this kind of thing easier. Actually, for the browser control method, it does download the images. In any case, have fun.

Good deal.

Not sure if it would help or not but if one looks at the html code for the Bill Gates, there is a tag for the img style="-webkit-user-select: none".

cheers

Originally Posted by Kenneth Hobson

Obviously, you can not use the method posted in the last link for an Image object. If you are going to use that method, use the WebBrowser control as they did.

I did a userform with their image and yours. In the VBE, be sure to set a reference in Tools > References to the Microsoft Internet Controls, if it shows missing in the attached file. I also did some tweaks to the code. I wanted the control to resize to the image size. Of course that is the advantage of downloading images, you can easily find the size and makes this kind of thing easier. Actually, for the browser control method, it does download the images. In any case, have fun.

Hello Kenneth, thank you once again for your help with this code. I've come across an issue that I hope you can help me figure out. The issue is that URL images I'm importing to the useform are company logos, which come in all shapes and sizes. I'd like to keep each logo's aspect ratio, but not their original size. In other words, I'd like all logos appear the center of an image object without any stretching and staying within the boundaries of the image object. Following are three examples, the fist two are "rectangular images" whereas the third is a "square image". Using the current code, the 3rd url image is stretched.

1. http://www.grainesdeboss.fr/photos/j...grosquadri.jpg
2. http://www.tabithasingapore.com/medi...1b_400x170.jpg
3. http://www.sefco-export.com/neer1.gif

Is there a way to accomplish this?

Thanks,

Noel

Hi Kenneth,
I'm bumping this hoping you or someone else can help me.
Thanks,
Noel

I've attached a sample file using Kenneth's code to demonstrate what I mean.

The 4th URL image in userform1 is the same as the 3rd URL image, but I had to manually enter this image's proper width and height to keep it's aspect ratio (almost square). As you can see the 3rd image looks stretched because it is using the WebBrowser3 object's width and height.

Is there a way to keep the URL image's original aspect ratio and "auto fit" into the WebBrower's object without stretching the image or having to predefine a width and height.

I need this image "auto fit" because I am referring to hundreds of company logos that have different widths, heights and aspect ratios, and any one of them may appear depending on other search criteria.

Thank you in advance for your help.

Noel

LoadPicFromURL.xlsm

I'm bumping this thread hoping someone can help me.
Thanks,
Noel