(Excel) Use HTTPS Client Certificate from .cer and .key Files

Demonstrates how to load a cert + private key from .cer and .key (base64) files and use it for mutual TLS authentication (client-side certificate).

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert
Dim privKey As Chilkat.PrivateKey
Set privKey = Chilkat.NewPrivateKey

' Load any type of certificate (.cer, .p7b, .pem, etc.) by calling LoadFromFile.

success = cert.LoadFromFile("qa_data/certs/sample_cert_a.cer")
If (success <> True) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' Load the private key.
Dim bd As Chilkat.BinData
Set bd = Chilkat.NewBinData
success = bd.LoadFile("qa_data/certs/sample_key_a.key")
success = privKey.LoadAnyFormat(bd,"privateKeyPasswordIfNecessary")
If (success <> True) Then
    Debug.Print privKey.LastErrorText
    Exit Sub
End If

' Associate the private key with the cert.
success = cert.SetPrivateKey(privKey)
If (success <> True) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' Set the certificate to be used for mutual TLS authentication
' (i.e. sets the client-side certificate for two-way TLS authentication)
success = http.SetSslClientCert(cert)
If (success <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' At this point, the HTTP object instance is setup with the client-side cert, and any SSL/TLS
' connection will automatically use it if the server demands a client-side cert.