Retrieve web image

[bradsalmon]

Hi all,

Does anyone know how to save a web image to a local hard drive in vba?

I can save across a html file and have done this for a while but I now
need to get specific images rather than a whole page and there's more
than I want to right click and save as on.

Any thoughts?

Thank you,

Brad

 

[bradsalmon]

Just in case anyone else has this issue as well.

I ended up building my own html page which referenced all the images,
opened this up and then did a save as in IE to get all the images.
Took a while to open the page but got there in the end.

Would still like a vba solution to getting the images if anyone comes
up with one.

Brad

 

[JP]

Is there any code here that might help?

http://www.codeforexcelandoutlook.com/AutomateInetExplorer.html


--JP

 

[Karl E. Peterson]

Does anyone know how to save a web image to a local hard drive in vba?

Well, the straight-forward way would be to call URLDownloadToFile:

http://vbnet.mvps.org/code/internet/urldownloadtofilenocache.htm

If you have access to VB6, and would like to do it asynchronously, the easiest thing
to do would be to build a UserControl that you could host in VBA. I think it'd be
as simple as making an OCX out of this:

http://vb.mvps.org/samples/NetGrab

In fact, if that sounds appealing, I'd be open to building and uploading that
myself. Lemme know.