list all images from website/intranet in excel sheet with vba

[Megatronixs]

Hi all,

I'm trying to find an image in a intranet. for some reasons I can find it in the website, but I can't find it in the html.
Is there a way that all the images from the intranet can be listed in an excel sheet?
I guess that it would be the same if it would be a current website

Thank you in advance.

[xlbiznes]

Does it mean that you are looking at all <img> tags in an url ?

[Megatronixs]

Hi xlbiznes,

That is correct. If all can be listed, maybe finally I can find the one I want :-)

Greetings.

[xlbiznes]

Here you go.

[Megatronixs]

Hi,

Thanks for the macro.
One question, is this an excel version specific? I tried it at home with excel 2013 and was giving me errors. I only can use the url from the second sheet, if I type something else, it will just error and do nothing.

Greetings.

[Megatronixs]

Hi,

I get: Permission to use object denied
I tried it on google.com, yahoo.com with no luck

Any idea why?

Greetings.

[Kyle123]

Try it on a site that doesn't redirect you to https

[Megatronixs]

Hi, I tried it on some pages and it worked fine, but the intranet is not showing nothing at all. Is like there are no images :-(
maybe because of different forms in the site (I only can guess).

Greetings.

[xlbiznes]

If you are using google chrome, Open your intranet page, right click on the image and choose inspect element.

Then you will know, under what sort of html tag the image is placed.

[Megatronixs]

Hi,

I need to use IE 8 for this. So all my automation's are based on that.
The ones I'm more interested in are the "src" part of the html

Greetings.

[Norie]

Why do you need to use IE8 for looking at the source behind the page/site?

PS Can you post the URL?

[xlbiznes]

I wanted you to find out what sort of element has the image details , so i asked you to use chrome for that. Only to check.

src is normally under and image tag (IMG).

[Megatronixs]

Hi,

Ok, now I see the question. I have only firefox en IE8 installed.
I will request chrome to be installed, but that will be tomorrow as in a few moments I'm going home :-)

Greetings.

[Megatronixs]

Hi,

I have this in the HTML:

The image I want to find (so I can click it, is: src="img/doc_doc_e.gif)

Hope you have a clue how to do this ;-)

greetings.

[xlbiznes]

Can you post your html source code of your intranet ?

Secondly , is your intranet content static web pages or dynamic content ?

[Megatronixs]

Hi,

It looks dynamic.
I can't post the html source code, sorry.

it needs an action before it will appear in the code windows of IE 8.

[xlbiznes]

This one list out all the cells inside a table (Html Table).

See if this works ?

[Megatronixs]

Hi xlbiznes,

It does not work as I would like it to work. the images are not appearing in the sheet. I guess that it has to do with the setup of the intranet site. When I run the macro with other pages, it does a good job.
I guess that this will be mission impossible.
I have a maybe different approach. I will try to use the mouse click via vba. So far I have some code that I added to maximize the IE8 window and then the mouse pointer will move to the position where the stupid image button is. For now, it does not click it as the IE window is not the active one, I need to play a little bit with it till it will really press the button.

Greetings.

[Megatronixs]

Hi all,

I will just give up on this as it does not work at all and I just spent to much time on it.

Big thanks to all of you that came up with some solutions.

Greetings.