Generate Random text password

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.



Sub Generate_Random_Password
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
Else
strPassword = Int((9 * Rnd) + 1) & strPassword
End If
Next i
ActiveSheet.Range("A" & n) = strPassword
strPassword = Empty
Next n
End Sub






Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us

Datanology

Leave a Reply

Your email address will not be published. Required fields are marked *