Add system time zone to a time stamp

[2Took]

How do I add system time zone to a time stamp, i.e. if my PC is set to EST then add (EST) at end of result of below code?

Better yet, if my PC is set to (UTC-7) for example, how do I have the code adjust to EST and produce EST result?

Sub LatestSaved()

Dim LS As String
 LS = "Latest updated:   " & Format(Now(), "ddd, mm.dd.yy - hh:mm")

Sheet1.Range("B3").Value = LS

End Sub

 

[Micron]

perhaps post 5 here

Can VBA Code detect time zone?

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...

www.mrexcel.com