Results 1 to 7 of 7

Thread: [Resolved]VBA/Excel2003 Digital Signature ?

  1. Dec 29th, 2005, 09:38 PM #1
    M.Nolan
    M.Nolan is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    81

    [Resolved]VBA/Excel2003 Digital Signature ?

    I have a project that is Digitally signed with a self certificate. When I install the XLS file on another computer and select "Trust" the file opens and closes fine. The problem is if the new computer makes changes and saves it discardes the certificate, but no changes were made to the Project only the file. I have had this work properly on other projects but this one is giving me some trouble. Any suggestions would be appriciated.
    Thanks.
    Matt
    Last edited by M.Nolan; Dec 29th, 2005 at 10:52 PM. Reason: Resolved
    Reply With Quote Reply With Quote
  2. Dec 29th, 2005, 09:55 PM #2
    M.Nolan
    M.Nolan is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    81

    Re: VBA/Excel2003 Digital Signature ?

    Looks like I have to SelfCert on each machine.
    ???
    Matt
    Reply With Quote Reply With Quote
  3. Dec 29th, 2005, 10:00 PM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: VBA/Excel2003 Digital Signature ?

    SelfCert is not really for distribution use either public or private. When a project is modified it does require to be re-signed.
    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
    Reply With Quote Reply With Quote
  4. Dec 29th, 2005, 10:09 PM #4
    M.Nolan
    M.Nolan is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    81

    Re: VBA/Excel2003 Digital Signature ?

    Thanks RD!
    Do small companies usually SelfCert at each machine or get a 3rd party certificate?
    What is a good 3rd party source ... one of the MS listed sources?
    Thanks again.
    Matt
    Reply With Quote Reply With Quote
  6. Dec 29th, 2005, 10:12 PM #5
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: VBA/Excel2003 Digital Signature ?

    If you only have a few users to support internally then you can get away with selfcert but for large number of users or for public distribution I would greatly suggest using 3rd party certs ONLY!

    Verisign is the industry standard but they cost a decent penney. Actually they are the only ones I know or but I'm sure a google search would bring up others but you get what you pay for.
    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
    Reply With Quote Reply With Quote
  7. Dec 29th, 2005, 10:13 PM #6
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: VBA/Excel2003 Digital Signature ?

    Also, did you install the cert in the Trusted store on each system? I have a thread on digital certs in CodeBank, fyi.
    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
    Reply With Quote Reply With Quote
  8. Dec 29th, 2005, 10:48 PM #7
    M.Nolan
    M.Nolan is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    81

    Re: VBA/Excel2003 Digital Signature ?

    Thanks again RD888!!
    I was just looking at that info in the codebank
    I will give it a try in the AM!
    Matt
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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