Cannot Copy Image with Varying URL from Webpage

[kalt]

Hi there, ive been looking all over the internet for answers to my problem but could find none.

I need to be able to copy a specific graph, in the form of an image, from a web page. This image always has the same name, "itmu-cpu-generic-lastweek." I already have to code to create an instance of internet explorer and go to the page, but cannot find how to copy that one image and not the whole web page.

I guess it does not really matter if it is copied to the clipboard or saved to the computer, as long as it is on my computer so that excel may grab it and throw it into a cell. Any help will be greatly appreciated

[Leith Ross]

Hello kalt,

Welcome to the Forum!

You don't need to Internet explore to do this. This macro will down a picture from a website provided you know the path. You can get the path by right clicking on the picture and clicking copy image location. It also lets you choose where to save the file. Copy this code into a separate VBA module in your workbook.

Please Login or Register  to view this content.

Demonstration routine, downloads an image from Excel Forum to the C: drive

Please Login or Register  to view this content.

[kalt]

Sorry for the late reply, I have been away from a computer for some time. I apologize royUK, if you could change the thread title to "Cannot Copy Image with Varying URL from Webpage"

Thanks Leith Ross for your reply, and I should have mentioned this above but the URL of the image is constantly different, which is what is giving me problems. I can get to the web page with no problem, but after that all I have to go by is the name of the image, "itmu-cpu-generic-lastweek" as it is labeled on the page and in the HTML. Any suggestions?

[Leith Ross]

Hello kalt,

Can you post the URL? I can then have a look at the page source and better answer your question.

[kalt]

Sure thing Leith but unfortunately you would not be able to reach the site as it is only accessible internally at my work. I can paste the sections of the page source that are relevant, let me know if you need more.

[Chippy]

Loop through HTMLDocument.images, looking for the image with the specified .alt property, and get its URL from the .src property. Then use Insert - Picture - From File - the URL, in Excel's Macro Recorder to generate the VBA code to download the image and insert it into a cell.

[kalt]

Loop through HTMLDocument.images, looking for the image with the specified .alt property, and get its URL from the .src property. Then use Insert - Picture - From File - the URL, in Excel's Macro Recorder to generate the VBA code to download the image and insert it into a cell.

Thanks Chippy, this looks like it could be exactly what I have been looking for. Only thing though: I'm not very good with html :/ . Could you provide a short example of what the code might look like?

I'll try tinkering around with it in the meantime.

[Leith Ross]

Hello kalt,

Here is an example macro using the call to download the picture to a file. You will need to change the URL, the FilePath, and the Alt property of the picture to what you need.

Please Login or Register  to view this content.

[kalt]

Thanks Leith, this code looks perfect. I'll give it a shot with rest of the code above.

[kalt]

Ok so I took the

Please Login or Register  to view this content.

of your code and threw in my part

Please Login or Register  to view this content.

instead of saving to the computer and I'm happy to say that it worked perfectly. Thank you so much Chippy for the idea and Leith for that excellent code

[Chippy]

Now please do the decent thing and post a link to this thread in your* cross-posted threads in other forums (i.e.. vbaexpress, ozgrid and several others), saying that your question has been solved and so people don't waste time working on it.

http://www.ozgrid.com/forum/showthread.php?t=155655
http://www.vbaexpress.com/forum/showthread.php?t=38086

*Unless I'm mistaken and by an amazing coincidence at least 2 different people have posted the same problem with the same wording on the same date on different forums