Datanology are providers of offline, credit based UK postcode lookups to enable users to validate customer address data and clean their datasets in bulk. Our systems allow users to cleanse, validate and standardise the street name, town/city & county in large datasets of customer addresses. It also allows customer databases to use lookups to auto populate the address in their CRM and know how many credits they still have and our bespoke CRM systems come with this feature added with a complimentary 100 lookups. It can easily be switched on and off as required.
As all our systems are built within Excel and are enabled for offline use, we provide a secure way to add credits following a small payment which means that your system can be topped up at any time using a 17 digit password. Our passwords are created by our own VBA script, an example is below. As the passwords created are random, they can not easily be guessed or replicated, and remain secure. The code below can be modified to create as many or as few passwords as you want in a list, with the number of characters of your choice.
We’d be happy to assist on any Excel or data project you are currently working on or looking to achieve. Leave a message below or contact us through the form. We’ll get straight back to you.
Dim strPassword As String
Dim i As Integer
For n = 1 To 10000
For i = 1 To 17
If i Mod 2 = 0 Then
strPassword = Chr(Int((90 - 65 + 1) * Rnd + 65)) & strPassword
strPassword = Int((9 * Rnd) + 1) & strPassword
ActiveSheet.Range("A" & n) = strPassword
strPassword = Empty