Distributing Excel Applications

  • Thread starter Thread starter Michael D. Ober
  • Start date Start date
M

Michael D. Ober

I need to distribute an Excel Application within our company.
Unfortunately, I have run up against the Excel 2002 macro security issue.
How can I create a signed macro using the MS Certificate Server in Windows
2000 that works?

TIA,
Mike Ober.
 
Anything in these to help?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_dsvba.asp
Code Signing Office XP Visual Basic for Applications Macro Projects

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288985
XL2002: About Digital Signatures in Excel Workbooks


http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)


An Overview:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo00/html/combat.asp

Another reference:
http://msdn.microsoft.com/library/en-us/odeopg/html/deovrsigningvbaproject.asp



http://support.microsoft.com/default.aspx?scid=kb;en-us;Q329228
OFFXP: How to Make Sure That Your Office Document Has a Valid Digital
Signature


http://office.microsoft.com/assistance/2002/articles/otelldigitalcertiftrustworthy.aspx
How to Tell if Digital Certificate Is Trustworthy in Office XP
 
I'll check this link and the links that Tom Ogilvy posted. As for why I
need to do this - it's an internal corporate application that Excel is the
best tool we have for. However, I need to do some serious preprocessing
(formatting, subtotalling, etc) before the user gets the data. Cross
process marshalling from VB6 is way too slow, so the actual VB code to do
the preprocessing needs to be in an Excel Add-In, which must be signed to
prevent the Excel Macro Security from preventing the application from
running.

Mike.
 
Back
Top