Implementing time synchronization through VBA

I am developing a small application that needs to include an audit trail function, with date and time stamping.To ensure that the time stamp is valid, I would like to either (1) force the local machine to synchronize with an external, trusted site (such as time-a.nist.gov), or (2) go and grab the time directly from an external, trusted site.

How on earth can I do this with VBA?

Searching on the Internet has shown up quite a few solutions that use C++ or C#, but that doesn’t help me much.I even found some that included a .FRM file – but they seem to be written in VB, and not VBA – I could not open those forms.

Does anyone know of a possible solution using VBA?

Thanks.

[1321 byte] By [mnptl] at [2008-1-10]