We need serveral tools to run from VBA (in various capacities) that take advantage of available 'web' resources.<br/>Intially (with others to follow as needed) we require a means to validate street addresses that are provided to us in varying file formats, with widely varying consitancies of textual format. Textual format intending to express such non-exclusive examples as; "123 Xyz Pl., There City, XX, 01234-5678", and "123&nbsp; Xyz Pl, thEre, xX&nbsp; 01234".<br/>One thought (while not exclusionary) would be to GeoCode via Google API's, or Bing, or any chosen suitable 'web-service' in order to validate and in some manner return to our VBA code the text values as delimeted address parts.