I am trying to use a macro to return further registration information from http://www.lawsociety.org.uk/find-a-...search#formtop to enable me to add data points to a database of current UK lawyers.

There appear to be a few ways to do so and I would like to know your thoughts on which will be most fruitful - 1) record a macro - import complete webpage and then select relevant data; copy and paste into table. 2) inspect the element of the search on the webpage and go direct to the information stored in the coding; this is then returned straight into excel with no import required (I've seen this done on a youtube clip and appears to be the slickest way) - this requires VB coding and not macros - so I have struggled thus far. 3) AN Other way - any ideas?

In essence, I have a list of forenames and surnames and I would like to use excel to match these up to company and searchable databases on the internet, to dramatically expand my database. I am searching around 100k names so this is an enormous time saver.

Happy to post further details on the project if it helps

Best

Harry