Postcode lookup UK

[hardy1976]

Hi,

I'm trying to find a list of addresses related to postcode, I've looked at the Free UK Postcode Lookup database (URL below) but it does not seem to work even when replacing the td class line (code below).

http://www.access-programmers.co.uk/forums/showthread.php?t=216444

"td class='address'>" 
with
"td class='js-ont-full-address ont-hidden-on-smaller-than-tablet'>"

It keeps timing out - does anyone have a solution to this issue or an alternative where you enter a postcode and it retrieves a list of addresses?

Regards

 

[JHB]

No timeout here. Change Database attached.
Try put in some breakpoint to see how far you get.
Maybe problem with your firewall/virus scanner?

 

[hardy1976]

It seems to be timing out on the

.send

?!

 

[JHB]

Are you in a company - maybe internal policy or something else.
Sorry - I'm not able to help you further then as earlier mention, no problem here.

 

[hardy1976]

Changing...

Dim winReq As WinHttpRequest
Set winReq = New WinHttpRequest

to....

Dim winReq As Object
Set winReq = CreateObject("MSXML2.XMLHTTP")

Fixed the issue - hope this helps someone else.

 

[ahmed_optom]

Im just getting the postcodes for nw10....

No matter what I put in the search field.

 

[isladogs]

You could have a look at my UK postcode address finder app.
http://www.mendipdatasystems.co.uk/uk-postal-address-finder/4594138311

However its not free as it does much more than just that.
An evaluation copy can be downloaded so you can see if its worth the cost for your purposes

EDIT
For info the postcode lookup file in your link / JHB post always gives addresses for the same postcode due to this code line:

 .Open "GET", "http://www.192.com/places/nw/nw10-0/nw10-0aw/", False

The code change suggested by Hardy1976 won't solve that issue