署名方法について (コード証明書関連)

Open office上でのVBA署名方法

Open office上でのVBA署名方法

Solution Open Office 2.0 マクロにおけるコード証明書を使った署名方法

This document details the process needed to sign Microsoft Office 2000 & XP VBA macros with a
Comodo Code-Signing certificate including a worked example. All web links are provided for
illustration purposes only, and are correct at time of publishing. It is recommended that the user
checks for any updates that may become available since the publishing of this document.

* Microsoft"s tool to import PVK files:

マイクロソフトよりPVK import ツールを ダウンロードしてください。 (pvkimprt.exe)

* Your code signing certificate from Comodo (as PVK and SPC files).

Click to obtain your Code Signing Certificate from Comodo


1. Install pvkimport you downloaded from Microsoft. Remember the paths to where you
installed it (c:\codesign\). You may also copy your certificate/key files to this directory
(mycert.spc & mykey.pvk).
2. Open a command-prompt and change to the folder where you installed pvkimport.
3. Combine your SPC and PVK certificate/key files that you received from Comodo into a
PFX file using pvkimport: (c:\codesign> pvkimprt -import –pfx c:\codesign\mycert.spc
This will start a wizard. Choose options:
Yes, Export the Private Key (チェック)
Include all Certificates in Path if possible (チェック)
Enable strong protection (チェック不要)
Delete the private key if export is successful (チェック不要)
Enter a password
Choose a location (c:\firefoxext\mycert.pfx)
4. You can check the private key has been imported successfully by using MMC. Open MMC,
select add/remove snap in and select certificates. Opening your code signing certificate
should show code signing usage and that you have the private key.
5. Within your Open Office 2.0 document, open the macro editor from the Tools – Macro
menu and generate your macro.
6. To sign the document macro, select Digital Signature from the Tools – Macro menu.
7. Select Add to chose to open up Select Certificate window.
8. Select your code-signing certificate and click OK to sign your document macro.
9. Click OK once again. Your document macro is now digitally signed.