Open webpage and click link based on cell value.

[Hyperion1571]

Afternoon all,

I am trying to see if it is possible to create a macro that would be able to open a web page and then click links within this web page based on cell value. once it has opened a page i then need it to pull data from this page into two columns in the spread sheet.

so the process would be in simple, Open web page, once page loads locate value that is in cell, then click link button that is in line with the found value, then copy two sets of data into the respective columns on the spread sheet followed by closing the website and moving to the next value in the table.

Is this possible? If so what information would be best to supply as its the first time I'm trying to do this kind of macro.

Many thanks in advance

[AB33]

Hyper,
It is difficult to say with out seeing the URL. Is it secure site? If it is not, I will have a go. Please attach a sample with URLs and what data you want to scape.