Time stamp and digital signature for VBA project

[BobG]

I'm able to use my code-signing ID from VeriSign to add my digital signature to my Office 2003 VBA project

I have looked everywhere, without luck, for exactly what I need to do to get a time stamp on my digital signature

Thanks in advance for your help!

 

[Lars-Eric Gisslén]

Bob,

Goal:
Timestamp an office script or file


Resolution:
By default, Office 2000 does not use a timestamping service when
signing or validating code. You cannot timestamp a digital signature unless
you are connected to the internet.

There is no built-in Office user interface to use this option. To have
Office use a timestamping service with all future digital signatures, you
need to set these registry keys:

HKEY_Current_User\Software\Microsoft\VBA\Security\TimeStampURL
HKEY_Current_User\Software\Microsoft\VBA\Security\TimeStampRetryCount
HKEY_Current_User\Software\Microsoft\VBA\Security\TimeStampRetryDelay

The TimeStampURL entry should be
http://timestamp.verisign.com/scripts/timstamp.dll (Note that the dll file
does not have an 'e')

TimeStampRetryCount is a DWORD registry key value that is the number
of retries VBA will attempt to connect to the timestamping server.

TimeStampRetryDelay is a DWORD registry key value that is the number
of seconds VBA will delay before retrying a connection to the timestamping
server.


--
Regards,
Lars-Eric Gisslén

I'm able to use my code-signing ID from VeriSign to add my digital

signature to my Office 2003 VBA project.

I have looked everywhere, without luck, for exactly what I need to do to

get a time stamp on my digital signature.

 

[BobG]

Thanks for taking the time to look into the problem

I've tried without success 3 different times to add the indicated registry keys/values but still don't get a time stam

By the way, the url for VeriSign works fine for me when I want to time stamp my .exe files as I sign them. Only problem is getting the timestamp on the macro project

Is is possible Office 2003 VBA time stamp procedures are different and that the code for time stamping Office 2000/2002 no longer works

 

[Lars-Eric Gisslén]

Bob,

I haven't tried signing with Office 2003 yet, seems like time to do that
now. I've only been signing with Word 2000 all the time. I have Word 2000 on
the machine with the certificate and not on the 2003 machine.

I only have the TimeStampURL key in the registry and it works without any
problems. I don't use the other two keys.

I must wait until tomorrow to test with 2003 as I must be at my job. I'l let
you know how it works for me with Word 2003.

--
Regards,
Lars-Eric Gisslén

Thanks for taking the time to look into the problem!

I've tried without success 3 different times to add the indicated registry

keys/values but still don't get a time stamp

By the way, the url for VeriSign works fine for me when I want to time

stamp my .exe files as I sign them. Only problem is getting the timestamp
on the macro projects

Is is possible Office 2003 VBA time stamp procedures are different and

that the code for time stamping Office 2000/2002 no longer works?

 

[Lars-Eric Gisslén]

Bob,

Works without any problems in Word 2003.

I suggest you remove the keys you added from the registry and try the
following

Open Notepad and paste the following text into Notepad:
-------------------------------------

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\VBA\Security]
"TimeStampURL"="http://timestamp.verisign.com/scripts/timstamp.dll"

-------------------------------------
Save to a filename like SetTimestampingURL.reg. Open Windows Explorer and
double click on the filename you saved the notepad contend in. Choose to set
the reg setting when asked to.

Should work.

Regards,
Lars-Eric Gisslén

Thanks for taking the time to look into the problem!

I've tried without success 3 different times to add the indicated registry

keys/values but still don't get a time stamp

By the way, the url for VeriSign works fine for me when I want to time

stamp my .exe files as I sign them. Only problem is getting the timestamp
on the macro projects

Is is possible Office 2003 VBA time stamp procedures are different and

that the code for time stamping Office 2000/2002 no longer works?

 

[BobG]

Thanks so much for your help!!

Everything's working ok for me now

Regards and best of luck in your work!

 

[Lars-Eric Gisslén]

Bob,

Thanks.

Glad you got it working. Next week it will be an Office 2003 week for me.
Will attend to the IW Bridge TAP workshop in Redmond. Seems to be new
technology for connecting Office 2003 to 'the rest of the world'. Will be
very interesting.