Is it possible to web-scrape image URLs using excel macros? To be clear, I want to scrape image-URLs and not the images.
If so, how?
I usually use the macros recorder to record functions that I don't remember, but the recorder doesn't pick up actions in my browser. So this suggests to me that it is not possible.
If not, what other tools have the function to data-scrape image urls?
Right now, to manually get image urls I have to go on the website, right-click on the image, and copy the image-url, and paste it into excel. There are over a 1000 images that I have to do this for. I have a long list of hyperlinks in excel.
Q: Is it possible to data-scrape image URLs using excel macros?
A: Yes.
Q: If so, how?
A: You learn VBA syntax first. Then learn about SHDocVw.InternetExplorer or MSXML2.XMLHTTP, both can help you to determine the rul of the desired image. Finally Download pictures from url and save in a folder named by a cell is an example to download image from url.