Sign Excel macro programatically

[TomBergman]

I create a large number of Excel spreadsheets programatically on a scheduled basis. This is done using VBA from a COM enabled application.
I'd like to add some simple macros. Adding these through COM is easy enough but with all the macro security in place in Excel, I will need to sign each of these before distribution.
I have no problem with buying a certificate from verisign, my issue is that I can't figure out a way to sign these spreadsheets programatically.
All of these spreadsheets are created without human intervention and I really can't have someone sign each one by hand.
Is this possible? Are there any examples available of scriptiong this? VB or VBscript examples would be great.

Thanks,

Tom

 

[KenPuls]

You know, this is kind of silly...

In Office 2003, there is a Signature object, as well as an AttachCertificate method. Both are supposedly "Office" objects, and yet they only seem to work with Word.

Ken Puls, CMA

http://www.excelguru.ca