(Excel) Write PKCS1 or PKCS8 Public Key PEM

Demonstrates how to write either PKCS1 or PKCS8 format PEM files. PKCS1 public keys have this PEM format:

-----BEGIN RSA PUBLIC KEY-----
BASE64 ENCODED DATA
-----END RSA PUBLIC KEY-----

-----BEGIN PUBLIC KEY-----
BASE64 ENCODED DATA
-----END PUBLIC KEY-----

Download Excel Class Modules Chilkat Excel Class Modules

' Unlock the Chilkat API.
' Starting in v9.5.0.49, 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 pem As Chilkat.Pem
Set pem = Chilkat.NewPem

' Load a public key from a PEM file.
' (Assume the PEM contains at least one public key..)
success = pem.LoadPemFile("/Users/chilkat/testData/pem/myPublicKey.pem")
If (success <> True) Then
    Debug.Print pem.LastErrorText
    Exit Sub
End If


numPublicKeys = pem.NumPublicKeys
If (numPublicKeys = 0) Then
    Debug.Print (("Error: Expected the PEM to contain public keys."))
    Exit Sub
End If

' Get each public key as PEM, first in PKCS1 format, then in PKCS8.
For i = 1 To numPublicKeys

    ' First output to PKCS1 PEM format:
    Debug.Print "This is PKCS1 format:"
    pem.PublicKeyFormat = "pkcs1"
    Debug.Print pem.ToPem()

    ' Now PKCS8 PEM format:
    Debug.Print "This is PKCS8 format:"
    pem.PublicKeyFormat = "pkcs8"
    Debug.Print pem.ToPem()

Next