[notquiteanexpert]

Hi Guys,

I want to get the actual current date in Excel or VBA. Obviously, if I just use today() or now() I get the current system date. This doesn't work for me because I want to userproof the fact that users can easily change the system date.

Does anyone have some code that I can use to somehow get the correct date, irrespective of what is set as the system date in Windows??

Thanks heaps.

[Advertisements]

Based on my experience (which isn't much! ) all date functions refer to the system clock one way or another, IMO.

[TheQuickBrownFox]

Based on my experience (which isn't much! ) all date functions refer to the system clock one way or another, IMO.

[Metallica]

Just to show that (*in theory) it is possible:
http://www.worldtime...ime_zone_guide/
but at $ 400 per year this one might be a bit too much.

[TheQuickBrownFox]

[Ax238]

If the user is connected to the Internet, you can use the approach outlined in the following page:
VB Helper: HowTo: Set the computer's time using the NIST atomic clock

Ax

[notquiteanexpert]

No worries. I'll just have to rely on the system date then....

Thanks guys.

[Ax238]

No problem