(Excel) Load an SSH Key from a File (Many Formats Supported)

Demonstrates how to load an SSH public or private key object from a file. The file can be in any of the following formats:

• OpenSSH private key
• OpenSSH public key
• PuTTY private key
• RFC 4716 public key

Download Excel Class Modules Chilkat Excel Class Modules

Dim sshkey As Chilkat.SshKey
Set sshkey = Chilkat.NewSshKey

' First, use the LoadText convenience method to load a text file (of any SSH key format)
' into a string:

strKey = sshkey.LoadText("../mySshKeys/myKey.txt")

' Next, load the key into the SSH key object.

' If the key is an OpenSSH private key:
' (In actuality, the From* methods will automatically detect the format and load
' the key correctly.  For example, if a PuTTY private key is passed to FromOpenSshPrivateKey,
' it  will still load correctly.)

success = sshkey.FromOpenSshPrivateKey(strKey)
If (success <> True) Then
    Debug.Print sshkey.LastErrorText
Else
    Debug.Print "Loaded OpenSSH private key."
    Exit Sub
End If

' If the key is an OpenSSH public key:
success = sshkey.FromOpenSshPublicKey(strKey)
If (success <> True) Then
    Debug.Print sshkey.LastErrorText
Else
    Debug.Print "Loaded OpenSSH public key."
    Exit Sub
End If

' If the key is a PuTTY private key:
success = sshkey.FromPuttyPrivateKey(strKey)
If (success <> True) Then
    Debug.Print sshkey.LastErrorText
Else
    Debug.Print "Loaded PuTTY private key."
    Exit Sub
End If

' If the key is an RFC 4716 public key:
success = sshkey.FromRfc4716PublicKey(strKey)
If (success <> True) Then
    Debug.Print sshkey.LastErrorText
Else
    Debug.Print "Loaded RFC 4716 public key."
End If