I'd like to do it in VBA. I have some knowledge of using VBA within excel to do simple things such as Case and IF statements but it is limited and I have tried with MapPoint but to no avail.

regards and thanks for your quick reply!