Digital Signed VBA. Sample for test.

[Joe]

Hi,
I have a excel sheet with VBA code and I was able to generate the self cert
and sign my vba. But I always see certificate status as following:
This CA Root certificate is not trusted because it is not in the Trusted
Root Certification Authorities store.
As such, I can't fully test my VBA with self cert under high security
environment.

Is there dummy VBA come with CA trusted root certificate available for
testing? Alternatively, I have to buy code sign from Verisign then had a root
trusted cert with VBA. But that could be not a good idea for testing purpose.

Please suggest if anybody had such a dummy vba but come with trusted root
cert.

best regards,
Joe.

 

[Tom Winter]

If you are using a certificate that YOU have generated, you're gonna have
this problem. You have to buy one from a real certificate authority.

 

[Joe]

Hi,
My question is if I can test a real certified VBA before I pay for my own
VBA. The testing VBA can be from Microsoft or other source, but it's no point
for me to pay even I'm not sure our server can properly authenticated signed
VBA.

In another words, my question is that if we gonna to buy a car before we
know how to drive it?

Best regards,
Joe.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Sm9l?=,

I have a excel sheet with VBA code and I was able to generate the self cert
and sign my vba. But I always see certificate status as following:
This CA Root certificate is not trusted because it is not in the Trusted
Root Certification Authorities store.

IE/Internet options/Content/Certificates. Choose your selfcert under the
Personal tab and click Export; note the path. Now move to the Trusted Root
Certificate tab and import the file you exported.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Joe]

Cindy,
It works.
Thanks,
Joe.

Hi =?Utf-8?B?Sm9l?=,

IE/Internet options/Content/Certificates. Choose your selfcert under the
Personal tab and click Export; note the path. Now move to the Trusted Root
Certificate tab and import the file you exported.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)


This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail