1

Topic: VBA Excel to pull out the data from the certificate.

Good afternoon, whether there is any possibility through VBA Excel to pull out the data (Period of validity, the supplier, an INN etc.) from a certificate file (*.cer) selected manually? Share ideas or links.

2

Re: VBA Excel to pull out the data from the certificate.

Bobax012;
Most likely is, set a certificate example.

3

Re: VBA Excel to pull out the data from the certificate.

iMrTidy;
Here is how an example to pull out the data since a line "Publisher" and certificate period of validity.

4

Re: VBA Excel to pull out the data from the certificate.

Example of extraction of the data from certificates: https://gallery.technet.microsoft.com/s … a742ebc2bb
There the utility certutil.exe with a key -decodeHex is used, but at me with your file this key did not work: "the Inadmissible data".
But certutil-dump produced (it is a text part)
[quote =]

 Issuer:
CN= Certifying center
OID.1.2.643.3.131.1.1=007710474375
OID.1.2.643.100.1=1047702026701
O= Russia
STREET=125375 Moscow, street Tver, . 7
L=
S=77 Moscow
C=RU
E=dit@minsvyaz.ru
NotBefore: 3/10/2017 15:36
NotAfter: 3/10/2027 15:36
Subject:
CN= "Electronic Moscow"
O= "Electronic Moscow"
STREET= The Suharevsky lane, .11, p. 1, .6
L=
S=77 Moscow
C=RU
E=support@e-moskva.ru
OID.1.2.643.3.131.1.1=007707314029
OID.1.2.643.100.1=1027707013806 

So can use.