Selecting the first object in a website table

[Megatronixs]

Hi all,

I have an intranet site that when I do a search, I get displayed in a table below the results. for 99% I should get one result, but it can happen that there could be at one point two results, but that is very rare.
Once I have the result, I need to select it so I can upload a document. I can't share the intranet site, but I have a link to a website with similar setup.

http://www.cqc.org.uk/search/site/me...e=15&mode=html

in the link, I would like to select with vba the first link that appears (KH Medical (Lundwood Medical Centre PMS Practice). As it is possible that the results will be different, it needs to select the first object from the table and not on name as the name could have different numbers behind (KH Medical (Lundwood Medical Centre PMS Practice-3389203883 as an example how it could look like and I don't have those numbers nowhere to compare. I only can think about: KH Medical (Lundwood Medical Centre PMS Practice* being the * as a joker)

Any help getting this would be great.

Greetings,

[Leith Ross]

Hello Megatronixs,

Because you are requesting help with an Intranet site, there are many company policies and security concerns. This often prevents you from supplying us critical information needed for a solution.

Add to that, you are presenting a "similar" site as a model. While the information may appear to be a close match in appearance, the underlying HTML could be completely different.

For example, you say your information (I am assuming on the intranet site and you have verified this point) is in a table. On the site you have posted, it is not in a table. It is in a Div element.

Unless you can post a copy of the HTML page source for the site you actually want data from, there is little we can do to help you.

[Megatronixs]

Hi,

Thanks for the info.
I will try to take apart the intranet site (save it as .mth) and then leave only those parts that I need to interact with and post them. This way I will comply with my company's policy and will be able to get it solved :-)
It is hard sometimes to find solutions when everything is so strict.

Maybe it is possible to show the possible solution for the above link? This way I could learn more :-)

greetings.

[Megatronixs]

Hi,

I managed to get some part of the html what is the interesting one.

As you can see, the last 2 parts are the ones I want to click. 99 procent there will be only one text link to click, but if there is a second one, it should be not used and go to the next part of the code. Let assume there is only the first one (ThisIsTheFirstOne_2014s1107eres105ee0_a_id), it should click that link. If it finds that there are more than 2, it should step out of the code (not click it).

I hope you will be able to help.

Thanks in advance and greetings.

[Megatronixs]

Hi,

maybe the below code could be edited to find the first one?

Please Login or Register  to view this content.

I'm just guessing what could be done to get the solution :-)

Greetings.

[Megatronixs]

Hi all,

Closing this one as a better solution could be made. I have started another thread that makes more sense:

http://www.excelforum.com/excel-prog...ml#post3902393

Hope some one can help out :-)

Greetings.