{"id":241,"date":"2016-01-19T14:04:53","date_gmt":"2016-01-19T14:04:53","guid":{"rendered":"http:\/\/www.pkipartner.support\/?page_id=241"},"modified":"2016-01-28T12:19:42","modified_gmt":"2016-01-28T12:19:42","slug":"codesign-vba-signing-open-office","status":"publish","type":"page","link":"https:\/\/pkipartner.com\/support\/codesign-vba-signing-open-office\/","title":{"rendered":"Codesign &#8211; VBA signing Open Office"},"content":{"rendered":"<h1>VBA signing Open Office<\/h1>\n<p>Signing Open Office 2.0 Macros with a Comodo Code-Signing Certificate.<\/p>\n<p>This document details the process needed to sign Microsoft Office 2000 &amp; XP VBA macros with a<br \/>\nComodo Code-Signing certificate including a worked example. All web links are provided for<br \/>\nillustration purposes only, and are correct at time of publishing. It is recommended that the user<br \/>\nchecks for any updates that may become available since the publishing of this document.<br \/>\nPre-requisites:<\/p>\n<p>* Microsoft&#8217;s tool to import PVK files:<\/p>\n<p>Download the <a href=\"http:\/\/www.microsoft.com\/downloads\/details.aspx?familyid=F9992C94-B129-46BC-B240-414BDFF679A7&amp;displaylang=en\">PVK import tool from Microsoft<\/a> (pvkimprt.exe)<\/p>\n<p>* Your code signing certificate from Comodo (as PVK and SPC files).<\/p>\n<p>Procedure:<\/p>\n<p>1. Install pvkimport you downloaded from Microsoft. Remember the paths to where you<br \/>\ninstalled it (c:\\codesign\\). You may also copy your certificate\/key files to this directory<br \/>\n(mycert.spc &amp; mykey.pvk).<br \/>\n2. Open a command-prompt and change to the folder where you installed pvkimport.<br \/>\n(c:\\codesign\\).<br \/>\n3. Combine your SPC and PVK certificate\/key files that you received from Comodo into a<br \/>\nPFX file using pvkimport: (c:\\codesign&gt; pvkimprt -import \u2013pfx c:\\codesign\\mycert.spc<br \/>\nc:\\codesign\\mycert.pvk)<br \/>\nThis will start a wizard. Choose options:<br \/>\nYes, Export the Private Key (check)<br \/>\nInclude all Certificates in Path if possible (check)<br \/>\nEnable strong protection (uncheck)<br \/>\nDelete the private key if export is successful (uncheck)<br \/>\nEnter a password<br \/>\nChoose a location (c:\\firefoxext\\mycert.pfx)<br \/>\nFinish.<br \/>\n4. You can check the private key has been imported successfully by using MMC. Open MMC,<br \/>\nselect add\/remove snap in and select certificates. Opening your code signing certificate<br \/>\nshould show code signing usage and that you have the private key.<br \/>\n5. Within your Open Office 2.0 document, open the macro editor from the Tools \u2013 Macro<br \/>\nmenu and generate your macro.<br \/>\n6. To sign the document macro, select Digital Signature from the Tools \u2013 Macro menu.<br \/>\n7. Select Add to chose to open up Select Certificate window.<br \/>\n8. Select your code-signing certificate and click OK to sign your document macro.<br \/>\n9. Click OK once again. Your document macro is now digitally signed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>VBA signing Open Office Signing Open Office 2.0 Macros with a Comodo Code-Signing Certificate. This document details the process needed to sign Microsoft Office 2000 &amp; 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\u2026<\/p>\n<p> <a class=\"continue-reading-link\" href=\"https:\/\/pkipartner.com\/support\/codesign-vba-signing-open-office\/\"><span>Continue reading<\/span><i class=\"crycon-right-dir\"><\/i><\/a> <\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/pages\/241"}],"collection":[{"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/comments?post=241"}],"version-history":[{"count":2,"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/pages\/241\/revisions"}],"predecessor-version":[{"id":610,"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/pages\/241\/revisions\/610"}],"wp:attachment":[{"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/media?parent=241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}