+ Reply to Thread
Results 1 to 6 of 6

How to get VBA Project Digital Signature Information

  1. #1
    Registered User
    Join Date
    07-02-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    40

    How to get VBA Project Digital Signature Information

    Can any one help in getting the VBA Project Digital Signature Information added to a particular workbook project.
    currently I can get only whether it is signed or not by using "thisworkbook.VBASigned".
    I want to get more information about the certificate added using VBA.
    Thanks in advance

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to get VBA Project Digital Signature Information

    why? I've never heard of anyone doing this. typically if you are writing the code, you sign it and the user see it as a trustworthy source.

  3. #3
    Registered User
    Join Date
    07-02-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: How to get VBA Project Digital Signature Information

    Hi
    Thanks for the reply, basically I want to cross check the signature which I provided.. People are adding self signed certificates instead of the one which I provided.
    so If the certificate modified, I want to discontinue the workbook.
    I used below code, but it is extracting the workbook signatures.

    Please Login or Register  to view this content.

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to get VBA Project Digital Signature Information

    Quote Originally Posted by sujithy007 View Post
    it is extracting the workbook signatures.

    Please Login or Register  to view this content.
    you mean it is NOT extracting the sigs? your code suggests that you are getting info along the lines of what you want. no?

  5. #5
    Registered User
    Join Date
    07-02-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    40
    Quote Originally Posted by vba_php View Post
    you mean it is NOT extracting the sigs? your code suggests that you are getting info along the lines of what you want. no?
    I am getting the signatures attached to workbook. Not to vba project.
    Those are coll.parent.signatures. I need coll.signatures. Its showing count=0 for vba project signatures.

  6. #6
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to get VBA Project Digital Signature Information


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. digital signature on pdf with vba
    By litman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2020, 01:05 AM
  2. [SOLVED] Do I need a Digital Signature??
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-12-2019, 07:47 AM
  3. [SOLVED] Digital signature
    By wanmuhd in forum Excel General
    Replies: 5
    Last Post: 06-11-2018, 12:07 PM
  4. [SOLVED] set up Digital signature
    By David Overington in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2006, 12:10 AM
  5. [SOLVED] Digital Signature
    By Sandy Mann in forum Excel General
    Replies: 5
    Last Post: 01-11-2006, 08:10 PM
  6. Digital signature
    By TLS in forum Excel General
    Replies: 0
    Last Post: 06-04-2005, 02:05 AM
  7. Digital Signature
    By JJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1