time zone of system should be inserted in cell with VBA

[Mehmud Khan]

hello,

good day!

I hope everyone enjoying the festival season!

I am using excel office 365 version.

is there any way to find the current time zone which set in the system.

I mean, if I have choose "(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi" in system then click on macro button then same time zone must be inserted in the cell.

Thanks and Regards,
-khan

 

[vletm]

how to display the system timezone in a excel cell ?

Hi Gurus Please help me in getting the Macros to display the system timezone in a excel cell. Appreciate you help. thanks Dinesh

chandoo.org

 

[Mehmud Khan]

how to display the system timezone in a excel cell ?

Hi Gurus Please help me in getting the Macros to display the system timezone in a excel cell. Appreciate you help. thanks Dinesh

chandoo.org

Hi Ninja,

Thanks for sharing the link.

But unfortunately, it won't work.

With the given Function codes + Formula, I am getting below result;



Which is not correct.


Regards,
Mehmud

 

[Marc L]

As it works as expected on our side no idea what's the weird on yours …​

​

 

[vletm]

Mehmud Khan​

There were ... many links
and
even better snapshot than Yours.



Q: What have You chosen?
Q: What have You tested?

 

[Mehmud Khan]

Hi,

vletm and Marc

Good day!


Yes! I have tested in correct way.

but I am getting "(UTC) Coordinated Universal Time" in the cell.

I have attached the file. Please check what is the result in your system.

If you get the correct time zone then the issued is with my excel as its "Excel 365"

If you also get above outcome then we need to improve in the formula.

thanks you so much for you time and enjoy the holiday season

thanks in advance.

regards,
-Khan

 

[vletm]

Mehmud Khan​

This code needs ... Windows ... I'll skip any tests.

 

[Marc L]

Please check what is the result in your system.

Your attachment works as expected on my side, so back to post #4 …​

As it is not a VBA native function so you have to search on OS forums.​

​

 

[Marc L]

Properties to check according to the original code :​

• Caption
• DaylightName
• Description
• StandardName

 

[Mehmud Khan]

marc and vletm...

I have really much hope from you...!

I know you can solve this issues.

What do you think... is there any issue in "Excel 365" version or something else??

As the same VBA is works fine in my "Excel 2016" version.

Regards,
-Mehmud

 

[vletm]

Mehmud Khan​

Your As the same VBA is works fine in my "Excel 2016" version.
... why You won't use it?

Have You tried below?

https://www.extendoffice.com/documents/excel/5372-excel-get-current-timezone.html

Get Timezone Information in VBA (Excel)

I would like to determine a time offset to GMT/UTC (including daylight saving time) for different countries at a specific date in VBA. Any ideas? EDIT (from self-answer): Thank you 0xA3. I quickly

stackoverflow.com

Untitled Page

www.cpearson.com

 

[Marc L]

is there any issue in "Excel 365" version

No according to post #8 …​

​