(Excel) Load a CSR and Examine the Contents

Demonstrates how to load a Certificate Signing Request (CSR) and examine the contents.

Note: This example requires Chilkat v9.5.0.65 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

' Note: Requires Chilkat v9.5.0.65 or greater.

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

Dim csr As Chilkat.Csr
Set csr = Chilkat.NewCsr

' Load a CSR PEM file.  The file should contain content that looks like this:
' 
' 	-----BEGIN CERTIFICATE REQUEST-----
' 	MIIC6jCCAdICAQAwgaQxITAfBgNVBAMMGG15c3ViZG9tYWluLm15ZG9tYWluLmNv
' 	bTELMAkGA1UEBhMCR0IxDjAMBgNVBAgMBVlvcmtzMQ0wCwYDVQQHDARZb3JrMSEw
' 	HwYDVQQKDBhJbnRlcm5ldCBXaWRnaXRzIFB0eSBMdGQxCzAJBgNVBAsMAklUMSMw
' 	IQYJKoZIhvcNAQkBFhRzdXBwb3J0QG15ZG9tYWluLmNvbTCCASIwDQYJKoZIhvcN
' 	AQEBBQADggEPADCCAQoCggEBALnQ0un/wF8whk+gPuiAlf3qvx14jgAOV6Erm6EB
' 	H7WACPCpnKcm/8KP+7uoPiwRQaENhMeCgf45vcivl2p6aAn/spLXyEkXyw2d8wFb
' 	YYAGRkiz4Xf7ASJiKuwcOtORz+sSDzgtdfokHfXU1cYeFE2yQhSdLUY5fMn425+g
' 	KoEEsRSjSDe6AKru4+4iGNrLKd8pB9IA5/jOE139IkWlB9r5fEPD5bUTsgqXk9eb
' 	68O0gc712V2eZK07N24lDmFC4bIMTD4csDWocR5hFHXj7NX7c8sOBDcpEb9mPIk4
' 	elxubnhkfnjhOi4J3lDHcT/0ALnbLhf9LnaiKqs+5VcVZvECAwEAAaAAMA0GCSqG
' 	SIb3DQEBBQUAA4IBAQC0AETLIcP3foh5nbu2hVFS8uCUNZ5hEIR1eXmYZmZoBQq2
' 	26ZAoT4CZwixlggC+n7WvAXJ5Pzxpl4wLV4loTiQzaKPX1w0ERo5ZRwLy0n56oG2
' 	6QG+WTViT1C8rlgtVwkCFNOXr0kSSRs8FdaPllqKxK1hxYSL7zwNpumsk39F2cDt
' 	vhcekvH0V3BuGrQFm3dKN/0azW6GOod9+Vq4VzSyOe3kp15oxLBsZOFOu/REujcw
' 	Tzu2jt1asQKUm60CZ9wNHpYepR0Ww40uP1slbehEaFDa6V8b60/tlHHmBbJ4/fy5
' 	hJnYCvjzFz4O9VtT+JtP9ldRHWV3KpZ8ne3AjD+F
' 	-----END CERTIFICATE REQUEST-----

Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess

csrPem = fac.ReadEntireTextFile("qa_data/csr/csr1.pem","utf-8")


success = csr.LoadCsrPem(csrPem)
If (success <> True) Then
    Debug.Print csr.LastErrorText
    Exit Sub
End If

' Examine the contents.
' If the CSR does not contain a field, the property will
' contain an empty string.

Debug.Print "Common Name: "; csr.CommonName

' Country Name (2 letter code)
Debug.Print "Country: "; csr.Country

' State or Province Name (full name)
Debug.Print "State: "; csr.State

' Locality Name (eg, city)
Debug.Print "Locality: "; csr.Locality

' Organization Name (eg, company)
Debug.Print "Company: "; csr.Company

' Organizational Unit Name (eg, secion/division)
Debug.Print "Company Division: "; csr.CompanyDivision

Debug.Print "Email Address: "; csr.EmailAddress