Need help adding code to VB

[Abbas999]

Hi Experts,

I have a excel spreadheet with around 60K addresses all around UK. I was finding for a solution that will receive these addresses as input and provide the output with the coresponding address GPS coordinates "Longtitudes and Lattitudes".

I have found a VB code on stackoverflow that will do the job. I Don't much about VB and how to enter a code in it and how to start or execute the commands.

For example COLUMN A have all the addresses and I want their longtitudes and lattitudes in COLUMN B.

Code is found there : Code to Get GPS Coordinates from Address (VB6/VBA/VBScript) - Stack Overflow

I am using MS OFFICE 2007 Version.
Please guide me to success. Thank you in advance

 

[mole999]

have a look at Batch geocoding, it won't do them all in one go