(Excel) Generating Random ASCII Strings

Demonstrates how to generate random us-ascii strings.

Download Excel Class Modules Chilkat Excel Class Modules

' All Chilkat classes can be unlocked at once at the beginning of a program
' by calling UnlockBundle.  It requires a Bundle unlock code.
Dim chilkatGlob As Chilkat.CkGlobal
Set chilkatGlob = Chilkat.NewCkGlobal

success = chilkatGlob.UnlockBundle("Anything for 30-day trial.")
If (success <> True) Then
    Debug.Print chilkatGlob.LastErrorText
    Exit Sub
End If

Dim fortuna As Chilkat.Prng
Set fortuna = Chilkat.NewPrng

' Generate random strings having only lowercase chars (a-z)
' Disallow digits and uppercase and only allow lowercase
bDigits = False
bUppercase = False
bLowercase = True

Debug.Print "-- only lowercase alpha (a-z)"
For i = 1 To 10
    ' Generate 20-character strings.
    Debug.Print fortuna.RandomString(20,bDigits,bLowercase,bUppercase)
Next

' Allow both lowercase and uppercase alpha chars
bUppercase = True
Debug.Print "-- lower and uppercase alpha (a-zA-Z)"
For i = 1 To 10
    ' Generate 20-character strings.
    Debug.Print fortuna.RandomString(20,bDigits,bLowercase,bUppercase)
Next

' Allow digits (0-9)
bDigits = True
Debug.Print "-- digits and lower/uppercase alpha (0-9a-zA-Z)"
For i = 1 To 10
    ' Generate 20-character strings.
    Debug.Print fortuna.RandomString(20,bDigits,bLowercase,bUppercase)
Next

' Allow only digits (0-9)
bUppercase = False
bLowercase = False
Debug.Print "-- only digits (0-9)"
For i = 1 To 10
    ' Generate 20-character strings.
    Debug.Print fortuna.RandomString(20,bDigits,bLowercase,bUppercase)
Next