GET UTC Time

[SBBmaster09]

Hi Experts,

How can I read the UTC time of the current station i am using. What I need is to detect and record it.

(UTC+01:00)

Please provide the function to be used or just give me the code to use. Thanks.

 

[namliam]

A quick google, https://www.google.nl/search?q=vba+gmt+time&hl=en-NL&gbv=2&oq=&gs_l=

Gives me this, good hunting

http://www.cpearson.com/excel/TimeZoneAndDaylightTime.aspx

 

[SBBmaster09]

I already looked in for the links you provided, what i need is a code in msaccess that Textfield = GetUTCTime

TextField values may display (UTC + 01:00)

 

[jdraw]

Did you look at this link that was in the material identfied by namliam
http://www.cpearson.com/Zips/modTimeZones.zip
that allows you to download the code from Chip Pearson's site?

It has all of the code shown on the site.

 

[SBBmaster09]

What file is it ? my computer can't read it. Thanks.