Hi there gurus,
I am looking for an Excel solution for address validation, for Australia.
Specifically, if a user types in an address I wish to check that the address exists, and if it doesnt, or if there is a typo such as street name McKenzie and not Mackenzie, or that address doesnt exist in that State (maybe the State entered is incorrect) so that a correction can be made at the time the data is entered.
I suspect there are a number of ways to do this, but not sure which would be the most efficient way.
It would be great if someone had a working solution, but I am also interested in knowing the hows and whys. I am ok with using an API that I would need to pay for, but would prefer a try before you buy option so I can test to see if it does what I need it to do.
I have an App that uses Application.FollowHyperlink "http://maps.live.com/default.aspx?where1=" & strAddress but I dont know how to use that for validation purposes. I can type in a typo and the address is found ignoring the typo. In other cases, if the address is not found, an error advising as such is not found is displayed. I just use that code to display the map.
Any help would be greatly appreciated.
I am looking for an Excel solution for address validation, for Australia.
Specifically, if a user types in an address I wish to check that the address exists, and if it doesnt, or if there is a typo such as street name McKenzie and not Mackenzie, or that address doesnt exist in that State (maybe the State entered is incorrect) so that a correction can be made at the time the data is entered.
I suspect there are a number of ways to do this, but not sure which would be the most efficient way.
It would be great if someone had a working solution, but I am also interested in knowing the hows and whys. I am ok with using an API that I would need to pay for, but would prefer a try before you buy option so I can test to see if it does what I need it to do.
I have an App that uses Application.FollowHyperlink "http://maps.live.com/default.aspx?where1=" & strAddress but I dont know how to use that for validation purposes. I can type in a typo and the address is found ignoring the typo. In other cases, if the address is not found, an error advising as such is not found is displayed. I just use that code to display the map.
Any help would be greatly appreciated.