I've not used Map Point before, so I can't advise you about automating this
step.
Will see what I can do.

NickHK

"brutonparish"
wrote in message
news:brutonparish.2aehuo_1151982604.4684@excelforu m-nospam.com...

NickHK: Thanks for the reply. Unfortunately I dont have the lat and
long. I can read it off a map but the intent to automate the process
will be lost. Anyways great link for future use.


--
brutonparish
------------------------------------------------------------------------
brutonparish's Profile:
http://www.excelforum.com/member.php...o&userid=35987
View this thread: http://www.excelforum.com/showthread...hreadid=557941