(Excel) Convert PuTTY Private Key (ppk) to OpenSSH (pem)

Convert a PuTTY format private key file (.ppk) to OpenSSH (.pem).

Download Excel Class Modules Chilkat Excel Class Modules

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

' Load an unencrypted or encrypted PuTTY private key.

' If  your PuTTY private key is encrypted, set the Password
' property before calling FromPuttyPrivateKey.
' If your PuTTY private key is not encrypted, it makes no diffference
' if Password is set or not set.
key.Password = "secret"

' First load the .ppk file into a string:

keyStr = key.LoadText("putty_private_key.ppk")

' Import into the SSH key object:
success = key.FromPuttyPrivateKey(keyStr)
If (success <> True) Then
    Debug.Print key.LastErrorText
    Exit Sub
End If

' Convert to an encrypted or unencrypted OpenSSH key.

' First demonstrate converting to an unencrypted OpenSSH key


bEncrypt = False
unencryptedKeyStr = key.ToOpenSshPrivateKey(bEncrypt)
success = key.SaveText(unencryptedKeyStr,"unencrypted_openssh.pem")
If (success <> True) Then
    Debug.Print key.LastErrorText
    Exit Sub
End If

' Save to an encrypted OpenSSH PEM file:

bEncrypt = True
key.Password = "myPassword"
encryptedKeyStr = key.ToOpenSshPrivateKey(bEncrypt)
success = key.SaveText(encryptedKeyStr,"encrypted_openssh.pem")
If (success <> True) Then
    Debug.Print key.LastErrorText
    Exit Sub
End If

Debug.Print "Done!"