excel macro to save the output image file from website (no change filename)

I would like to run an excel macro to open an image from website, prefer to save the filename exactly same. The reason behind is when the image does not exist, then the website will direct me to download "imagenotfound.png". I wish to keep track on those. anyone can help pls?

I've checked most of the forum, the filename is manual, can I save directly same filename as what the URL prompted me?

thx

I actually have a list of URLs (which directs me to get an image file for each) in a column of the excel file. I am trying to check which image does not exist. However, the problem I am facing is, whenever the image not there, it's automatically prompts me on the "imagenotfound.png" which makes me difficult, especially I did try to disable the redirection of URLs already. Seems the output still telling me the image still there.

In that case, I am trying alternative, trying to capture the output image filename as above, but seems not easy. Is that limitation of excel macro? Pls advise. Thanks.

THanks Leith - I have PM you for the samples. Pls help. thx.

Is that the excel macro limitation that we cannot save the file with filename same as the prompt up image filename? We must put a specific filename if we wish to save the file locally to check? thanks.

I am not sure if my thinking is good or not. Would there be some codes that can answer the application automatically to save the file (not save as)? After that, I call another function to check the filename that is saved to the path? In that way, I can see if the image is found or not?