In my previous blog post I gave a list of Slovenian postal codes based on a revision of an online source. Below I give you a Google based object oriented VBA solution, which easily generalizes to parsing of other xml sources. Geocoding can have an enormous impact on presentations and requires a careful processing. I use an automated VBA routine inspired by the code below, but still find that inspection is necessary. Often there are several loations of observations, businesses or respondents in a survey, that have to pinpointed using auxiliary information, which depends on the problem at hand. Have a look at www.hellmund-laier.dk VBA module Option Explicit Public xmlDoc As MSXML2.DOMDocument60 Public Function lat(searchfield As String) Dim googleUrl As String googleUrl = "http://maps.googleapis.com/maps/api/geocode/xml?address=" & searchfield & "&sensor=false" Set xmlDoc = New MSXML2.DOMDocument60 xmlDoc.async = False xmlDoc.Load (google