- Hot Topics
Excel Can this UK Postcode Lookup be converted from Access to Work with Excel
I've found some code that looksup online UK postcodes and returns all matching addresses in an Access Form. I wonder if it's possible to do something similar in Excel? Here is the example code from Access: Code: Option 'Requires Private Me.List2.RowSource = "" Dim Pcode, sStr As String 'First up, Format the postcode Pcode = UCase(Replace(Text0, " ", "")) Select Case Len(Pcode) Case 5 Pcode = Mid(Pcode, 1, 2) & " " & Case 6 Pcode = Mid(Pcode, 1, 3) & " " & Case 7 Pcode = Mid(Pcode, 1, 4) & " " & End Select 'Now create the search string 'http://www.192.com/places/ab/ab10-1/ab1 sStr = "http://www.192.com/places/"
This question generated 22 answers. To proceed to the answers, click here.
This thread is current as of October 8, 2013.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel