Can VBA Code detect time zone?

[pedie]

Hi,
I have been thinking that there could be a way to find out what time zone is the user in....
I came across the post in cpearson's site....but couldn't make it work..
I want cell 1 to show show what time zone is the user in. EST or other time zone etc.
Any suggestion and ideas would be great.
Thanks in advance.

 

[Ruddles]

GetTimeZoneInformation and GetSystemTime have been together so long, I didn't like to split them up!

 

[Beeguyel1]

Old thread, but do you guys mind if I ask for some more clarification--re automatically writing the user's time zone to a cell? I'm still a newB, and have hit a brick wall.

I haven't been able to write the time zone to a cell as Pedie succeeded in doing.

My actions thus far:

With Pearson's code I was able to use:

"=DaylightTime()"
"=LocalOffsetFromGMT(NOW())"

I entered the code you posted into a fresh module, and ran macros. I also called it and ran it as part of a loop I have for other macros. No dice.

Other info:

I still have Pearson's downloaded BAS module running separately as well.
I attempted to alter the (0 to 31) to (32), with no changes.