Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Mono C#.NET Core C#C# UWP/WinRTDataFlexDelphi ActiveXDelphi DLLVisual FoxProJavaLianjaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerBuilderPowerShellPureBasicCkPythonChilkat2-PythonRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++Visual Basic 6.0VB.NETVB.NET UWP/WinRTVBScriptXojo PluginNode.jsExcelGo

Excel Examples

Web API Categories

ASN.1
Amazon EC2
Amazon Glacier
Amazon S3
Amazon S3 (new)
Amazon SES
Amazon SNS
Amazon SQS
Azure Cloud Storage
Azure Service Bus
Azure Table Service
Base64
Bounced Email
Box
CAdES
CSR
CSV
Certificates
Compression
DKIM / DomainKey
DSA
Diffie-Hellman
Digital Signatures
Dropbox
Dynamics CRM
EBICS
ECC
Ed25519
Email Object
Encryption
FTP
FileAccess
Firebase
GMail REST API
GMail SMTP/IMAP/POP
Geolocation
Google APIs
Google Calendar
Google Cloud SQL
Google Cloud Storage
Google Drive
Google Photos
Google Sheets
Google Tasks
Gzip
HTML-to-XML/Text
HTTP

HTTP Misc
IMAP
JSON
JSON Web Encryption (JWE)
JSON Web Signatures (JWS)
JSON Web Token (JWT)
Java KeyStore (JKS)
MHT / HTML Email
MIME
MS Storage Providers
Microsoft Graph
NTLM
OAuth1
OAuth2
OIDC
Office365
OneDrive
OpenSSL
Outlook
Outlook Calendar
Outlook Contact
PDF Signatures
PEM
PFX/P12
PKCS11
POP3
PRNG
REST
REST Misc
RSA
SCP
SCard
SFTP
SMTP
SSH
SSH Key
SSH Tunnel
ScMinidriver
SharePoint
Socket/SSL/TLS
Spider
Stream
Tar Archive
Upload
WebSocket
XAdES
XML
XML Digital Signatures
XMP
Zip
curl

 

 

 

(Excel) Duplicate openssl pkcs12 –export –in certfile.cer –inkey certfile.key –out certfile.pfx

How to create a PKCS12 (.p12 or .pfx) from a certificate file and private key file: Demonstrates how to duplicate this OpenSSL command:

Duplicate openssl pkcs12 –export –in certfile.cer –inkey certfile.key –out certfile.pfx

Download Excel Class Modules

Chilkat Excel Class Modules


' The PFX class requires the software to be unlocked..
Dim global As Chilkat.CkGlobal
Set global = Chilkat.NewCkGlobal
success = global.UnlockBundle("Anything for 30-day trial")
If (success <> True) Then
    Debug.Print global.LastErrorText
    Exit Sub
End If

Dim pkey As Chilkat.PrivateKey
Set pkey = Chilkat.NewPrivateKey

' Load the private key from the file.
' There are several methods for loading private keys from a file:
'     LoadPkcs8File
'     LoadRsaDerFile
'     LoadPemFile
'     LoadPvkFile
'     LoadXmlFile
' In actuality, it doesn't matter which one is called. In all cases
' Chilkat will automatically recognize the format of the private key
' file and load it correctly.  Therefore, even if actual contents
' of the file does not agree with the name of the method, it will still work.
' The only way it won't work is if it's not actually a private key file
' (perhaps it is only a public key file), or perhaps the private key
' file is encrypted and requires a password.  In that case, you would
' call one of the Chilkat methods to load the encrypted private key file
' (and these methods include an argument to specify the password).
success = pkey.LoadPkcs8File("certFile.key")
If (success <> True) Then
    Debug.Print pkey.LastErrorText
    Exit Sub
End If

Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert
' The LoadFromFile method auto-recognizes the format...
success = cert.LoadFromFile("certfile.cer")
If (success <> True) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' We'll need a cert chain object to create the PKCS12, so get it
' from the cert.  

Set certChain = cert.GetCertChain()
If (Not cert.LastMethodSuccess) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' Create the PFX object, add the cert and private key, and write to a .pfx file.
Dim pfx As Chilkat.Pfx
Set pfx = Chilkat.NewPfx

' The cert(s) are automatically added in the call to AddPrivateKey
success = pfx.AddPrivateKey(pkey,certChain)
If (success <> True) Then
    Debug.Print pfx.LastErrorText
    Exit Sub
End If

' Write the .pfx to a file.

password = "myPassword"
success = pfx.ToFile(password,"certfile.pfx")
If (success <> True) Then
    Debug.Print pfx.LastErrorText
    Exit Sub
End If

Debug.Print "Success."

 

© 2000-2022 Chilkat Software, Inc. All Rights Reserved.