Solved

How to create a vba code that will get system time zone and determine whether or not its daylight savings time in excel?

Posted on 2015-01-19
3
348 Views
Last Modified: 2015-01-19
How to create a vba code that will get system time zone and determine whether or not its daylight savings time in excel?
0
Comment
Question by:kbay808
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
Flora earned 500 total points
ID: 40558981
here is a very detailed VBA for Timezone and daylight saving.

http://www.cpearson.com/excel/TimeZoneAndDaylightTime.aspx
0
 
LVL 6

Expert Comment

by:Flora
ID: 40558982
0
 

Author Closing Comment

by:kbay808
ID: 40559187
Thank you
0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question