How to derive system time zone

[ThrottleWorks]

Hi,

I need to process data based on the time zone of the user’s system.

Sometimes, user’s system might be configured to GMT, sometimes system might be running for IST.

How to derive system time zone through VBA.
Can anyone please help me in this.

 

[shrivallabha]

Check this thread:
http://stackoverflow.com/questions/3120915/get-timezone-information-in-vba-excel

 

[ThrottleWorks]

Hi @shrivallabha thanks a lot for the help. I am checking this.

Good night.

 

[ThrottleWorks]

Hi @shrivallabha , I am trying below code. Found at Chandoo only !

Good night.

http://forum.chandoo.org/threads/how-to-display-the-system-timezone-in-a-excel-cell.29641/

Sub GetMyTimeZone()
    Dim strPath As String
    strPath = GetTimeZone
    MapSht.Range("D2").Value = strPath
End Sub
Function GetTimeZone() As String
    Dim oItem, colItems
    Application.Volatile True
    Set colItems = GetObject("winmgmts:\\.\root\cimv2").ExecQuery("Select * From Win32_TimeZone")
   
    For Each oItem In colItems
        GetTimeZone = oItem.Caption
    Next
End Function

 

[SirJB7]

I am trying below code. Found at Chandoo only !

Hi, ThrottleWorks!
You're always digging in such kinda places...
Regards!

 

[ThrottleWorks]

Hi @SirJB7 sir, well, that is my one of the most favourite place to hang out (when hanged with issues).