Excel VB determining if eastern standard or daylight savings time

[Heidi]

I am writing an Excel VBA macro and need to determine if a date is eastern
standard or eastern daylight savings time in Visual Basic. Is this possible?

I am using Excel 2003.

 

[Tom Ogilvy]

There may be an easier way, but this article tells how to change the time
zone. However it first tells you how to get the time zone.

http://support.microsoft.com/default.aspx?scid=kb;en-us;221542
How to change time zone information by using Visual Basic