Copying a picture from a web page and pasting into Excel

[tom566]

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 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 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

 

[John_w]

Does the image have a static (i.e. unchanging) URL? If so, copy the URL to the clipboard, then in Excel: Insert - Picture - From File - paste the URL as the File name - Insert.

 

[tom566]

Nope, the url is not always exactly the same, which is giving me the problem. I do know the name of the image on the page as I mentioned above, and the name never changes. Is there any way for me to grab the picture by just knowing this information?

 

[John_w]

It's difficult to help you without knowing the URL of the web page containing the image, or the HTML code surrounding the image. As a guess you would probably need to extract the src=xxxx string from the < IMG > tag.

 

[Hap]

John, I'm have a similar issue trying to load or save an image from a page. I am using a google static maps api and creating the addresses dynamically from a form. A sample would be:

http://maps.googleapis.com/maps/api...=14&size=512x512&maptype=roadmap&sensor=false

What is returned is a page with a single static image file on it. I would like to save this image to the same path as my activeworkbook programmatically. Any ideas?

 

[John_w]

Try URLDownloadToFile (search for examples). ActiveWorkbook.Path is a string containing the folder path of the current workbook.

 

[Hap]

Thank you!! I think I've got it figured out with the exception I have a username and password issue getting the program to dynamically connect to the net. I'm using 2000 so the example I had for passing the username and password wasn't working.