(Excel) Italian FatturaPA (e-Invoice) Signed XML (CADES-BES P7M) using USB SmartCard Reader

Demonstrates Italian e-Invoice (FatturaPA) signing by using a private key stored on a USB smartcard reader.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2
crypt.VerboseLogging = True

Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert
' Use your smart card user PIN for signing.
cert.SmartCardPin = "0000"


success = cert.LoadFromSmartcard("")
If (success = False) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

success = crypt.SetSigningCert(cert)
If (success = False) Then
    Debug.Print crypt.LastErrorText
    Exit Sub
End If

' The CadesEnabled property applies to all methods that create PKCS7 signatures. 
' To create a CAdES-BES signature, set this property equal to true.
crypt.CadesEnabled = True

crypt.HashAlgorithm = "sha256"

Dim signedAttrs As Chilkat.JsonObject
Set signedAttrs = Chilkat.NewJsonObject
Dim success As Boolean
success = signedAttrs.UpdateInt("contentType",1)
success = signedAttrs.UpdateInt("signingTime",1)
success = signedAttrs.UpdateInt("messageDigest",1)
success = signedAttrs.UpdateInt("signingCertificateV2",1)
crypt.SigningAttributes = signedAttrs.Emit()

' Load XML such as the following:
'  <p:FatturaElettronica xmlns:p="http://ivaservizi.agenziaentrate.gov.it/docs/xsd/fatture/v1.2" versione="FPR12">
'     <FatturaElettronicaHeader>
'        <DatiTrasmissione>
' 	...
'        </DatiTrasmissione>
'        <CedentePrestatore>
' 	...
'        </CedentePrestatore>
'        <CessionarioCommittente>
' 	...
'        </CessionarioCommittente>
'     </FatturaElettronicaHeader>
'     <FatturaElettronicaBody>
'        <DatiGenerali>
'           <DatiGeneraliDocumento>
' 		...
'           </DatiGeneraliDocumento>
'        </DatiGenerali>
'        <DatiBeniServizi>
' 	...
'        </DatiBeniServizi>
'     </FatturaElettronicaBody>
'  </p:FatturaElettronica>


inputXmlPath = "c:/someDir/e-Invoice.xml"

outputP7mPath = "c:/someDir/signed.p7m"

' Create the CAdES-BES attached signature, which contains the original data.
success = crypt.CreateP7M(inputXmlPath,outputP7mPath)
If (success = False) Then
    Debug.Print crypt.LastErrorText
    Exit Sub
End If

Debug.Print "Success."