[SOLVED] 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...b;en-us;221542
How to change time zone information by using Visual Basic

--
Regards,
Tom Ogilvy




"Heidi" <Heidi@discussions.microsoft.com> wrote in message
news:63363626-A125-4136-814F-9E5B51E51225@microsoft.com...
> 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.