Mapping UK postcodes

[RebaMc]

Hi there,

I've tried doing a search, but I've not had much luck.

I have no idea where to start on this one. I'm using Excel 2003 and would like to use a list of UK postcodes to show as pin points on a map of the UK. Is there any way of doing this in Excel?

Thanks in advance,

Rebecca

 

[Lewiy]

I would imagine that you would need a large image of the <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:country-region w:st="on"><st1lace w:st="on">UK</st1lace></st1:country-region> and a “grid reference” for each and every postcode that references a “position” on the worksheet. You could then have another image (of a pin or something) that you can change the position of based on the grid reference.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Sounds like a laborious task though. I’m sure this would be easier to do by linking to a website like streetmap.co.uk where all this data is already available.

 

[GlennUK]

Hi there,

I've tried doing a search, but I've not had much luck.

I have no idea where to start on this one. I'm using Excel 2003 and would like to use a list of UK postcodes to show as pin points on a map of the UK. Is there any way of doing this in Excel?

Thanks in advance,

Rebecca

Apparently this is a piece of cake:
http://www.microsoft.com/mappoint/products/2006/assistance/excel.mspx

But it uses MapPoint. My colleague says it really easy.

 

[iliace]

http://www.jibble.org/ukpostcodes/

EDIT: Never mind, broken link. Looked good in theory.

 

[GlennUK]

Cheapo old version of MapPoint:

http://www.trustedgoods.com/product_p/b21-00399.htm?gclid=CNmGtqet-ZQCFQ8gQgodGWprrQ

 

[RebaMc]

Cheers Glenn... they look just the thing.

 

[GlennUK]

My pleasure.