Clicking a link which has no name. IE with VBA

Just wondering if anyone's been able to click a link which as no name?

I am currently building an automated certificate downloader for various websites (UL, TUV, IMQ, IEC etc). The Excel workbook will have various cells which upon running of code will go out to the various websites, enter cell information into the online forms, submit the information then open the reliant link within the website.

The problem is that most of these websites have click-able links with no clearly defined attributes except for text relating to different certificate data, Certificate number, Manufacturer, model, etc...

I have been successful in opening the websites, filling in certain fields within the forms and submitting forms.

The Element information I've been able to extract from one site (VDE) is as follows, this holds the link to the certificate I wish to proceed to...

HTML Code: 

So far I've been able to fill a textbox and click on that but I can't work out how to click on the link then on the next page.

CODE SO FAR

------------------------------working--------------------------------------

Please Login or Register  to view this content.

Any help would be greatly appreciated and I look forward to reading some possible solutions

Use this line

Please Login or Register  to view this content.

Hi Norie,

Thanks for the prompt response.

I can't find any HREF for it at all.

The full class is as follows;

HTML Code: 

Link to table - http://www.vde.com/en/institute/onli...29a7726c860edf

I think the problem could be resolved by somehow using On-Click but research has gotten me nowhere....

Norie,
Thanks you for spotting!
I have also found that, there is no tagname called ms-vb2, but it is a class with in a table.

Hi AB33,

Thanks too for the help...

How can I use a class within a table to open the link?

As far as I know, the line(tag, ID or class ) should have an anchor.
<a href/>

Please Login or Register  to view this content.

You can use "a" as tagname and if has children, you can loop through.

Code tried to date none of which wil lopen the link associated with "40000358"

Please Login or Register  to view this content.

Ohm, I suspect it is a java script link.

Are you trying to click on this link?




Certificate no. Company Product First types
40000358 Xiamen Faratronic Fixed capacitor for electromagnetic interference suppression and connection to the supply mains MKP62

Clicking anywhere on the row will bring you to the same certificate, however, some entries bring up alot of listings (http://www.vde.com/EN/INSTITUTE/ONLI...3d4db47c259874) I wish to filter through these by using the first cell (which has a number associated with it) and loop through these untill they match one within a workbook cell.

Hi AB33

Yes, the first cell within the returned form "40000358" however I wish to match this number first then click on it...

I suspect you are trying to get these data

Certificate no. 40000358


Product Fixed capacitor for electromagnetic interference suppression and connection to the supply mains
Product group RFI-suppression capacitors
Company Xiamen Faratronic
Co. Ltd.
99 Xinyuan Road,
Haicang
361022 XIAMEN
Fujian
CHINA
Certification mark ENEC Mark and/or VDE Mark


Type Technical Data
MKP62 Rated voltage: a)b) AC 275 V oder / or AC 305 V c) AC 275 V order/or AC 305 V order/or AC 310 V


The problem is none of the innertext are part of the anchor tag. I think the link is javascript.

This link work, but I am not sure if this is what you want.

Please Login or Register  to view this content.

Thanks AB33,

I'll try this tomorrow morning when I'm back at the desk and report back.

Thanks again for the help...