VBA to send data from excel spreadsheet to a website form and return result to spreadsheet

[daveandnat58]

Hi all
Can anyone please help with providing code that would allow me to:


1. Send each of the numbers in column A of a spreadsheet (and indeed any amount of numbers included in column A) eg these numbers:-

238554836
166913834
205963701
343475355
220430231
to http://ec.europa.eu/taxation_c.....toms/vies/



2. Select GB-United Kingdom on the top down menu


3. Enter each of the numbers in turn into the VAT number box below the above drop down


4. Return the name of the relevant business back to the spreadsheet in column B next to the original VAT number

Any help would be much appreciated?



Thanks
Dave