|
-
Jul 10th, 2007, 10:48 AM
#1
Thread Starter
Addicted Member
[RESOLVED]Digital Certificates
Hi,
I am looking to publish a number of books to 5 people using 5 different machines.
i have inserted my digital certificate in the book, and trusted it on my machine
Unfortunatley as this is a self signed cert, it is currently not trusted on the other users machine (which is obvious)
what i am wondering is when i export the cert from my machine, is there anyway to export the keys also
at the moment they are currently greyed out.
out techys in work purchased a cert from verisign, but it looks as though its intended purposes is not for signing code
it is for client auth, and email sending
pricing the code signing cert from verisign i think its £600
as this is only needed for five machines, is there any way to use the self signed certificates?
sorry for the essay, any help would be appreciated
Mitch
Last edited by Mitch_s_s; Aug 24th, 2007 at 09:26 AM.
Reason: resolved
-
Jul 11th, 2007, 10:51 PM
#2
Re: Digital Certificates
yes, it can be done, but i think you have to create the selfcert on each machine you want to use it on, i only have one machine here at present so can't test, but i have done it before on a customers machine, can't remember if i had to sign the macro on each machine
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Jul 12th, 2007, 02:32 AM
#3
Re: Digital Certificates
If each workstation has Office installed then you can use each workstations selfcert.exe to create a private certificate. These certs are local to the machine only. They are generated and validated with a hardware alogorithum so moving them to other systems renders them useless.
You may need to install the selfcert utility from the Office CD as you re-run the install and select the option from the tools orcommon options.
There are cheaper certs available from other sources then verisign.
http://www.instantssl.com/code-signing/
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum. 
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it! 
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6 
-
Jul 13th, 2007, 01:45 AM
#4
Thread Starter
Addicted Member
Re: Digital Certificates
thanks for your help
i wouldnt be able to use the selfcert on each machine as you can only sign the project once
and the 5 machines will all be using the same files
thanks for the link, i will have a look at them now
the cheaper the better!
-
Jul 13th, 2007, 01:51 AM
#5
Re: Digital Certificates
No, you can sign it multiple times. If your having trouble you can unsing it and then resign it. This must be done on each system where you generate it own local cert.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum. 
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it! 
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6 
-
Jul 13th, 2007, 01:57 AM
#6
Thread Starter
Addicted Member
Re: Digital Certificates
Sorry to be a pain, Just so i understand this correctly
the project can have multiple certificates attached to it at once?
i'll have a play around now, as in VBA it only seems to allow me to attach one cert :s
-
Jul 13th, 2007, 02:01 AM
#7
Re: Digital Certificates
No, just one cert at a time. If you generate a private local cert on each system with selfcert and then on that system sign the project it will work. Then replicate the process of cert generation and signing on each of the other systems one at a time, each one unique and different cert from the others.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum. 
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it! 
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6 
-
Aug 24th, 2007, 09:05 AM
#8
Thread Starter
Addicted Member
Re: Digital Certificates
Sorry to resurrect and old topic, I have now purchased a cert from instantssl.com
Is there any way to sign a project programatically?
I am asking as I have over 100 projects that need signing at it will take me some time to add the certs to each one.
If I cant, then no problem - just asking as it will save me some time.
Thanks Mitch
-
Aug 24th, 2007, 09:08 AM
#9
Re: Digital Certificates
I dont think so. If there is I would think that would be a security issue but cant say I have ever come across any functions for signing projects. Im sure I may have seen it if there was one.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum. 
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it! 
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6 
-
Aug 24th, 2007, 09:26 AM
#10
Thread Starter
Addicted Member
Re: Digital Certificates
looks like i'm going to get RSI ha!
thanks anyway
-
Aug 24th, 2007, 04:43 PM
#11
Re: [RESOLVED]Digital Certificates
try recording a macro to see if there is code to do it
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|