How to get Timezone in VBA (for Excel)?

[Devangi Gandhi]

Hi,

I need to figure out how to capture the timezone setting
for the local machine and then convert it to GMT? Any
tips on how to do this, with considerations for Daylight
savings time etc...

Thanks!

 

[Chip Pearson]

Devangi,

See http://www.cpearson.com/excel/timezone.htm for information and
an example workbook. You'll want to use the CTime class in the
sample workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Devangi Gandhi]

Hi Chip,

The converttoGMT function you have provided only converts the time
portion to GMT, but it does not convert the date.

E.g. Now = 7/31/2003 13:47
and if I do converttoGMT(7/31/2003 13:47) I get 18:47:10, I don't get
the date portion 7/31/2003...

I am new to Excel VBA programming and if youcan help me here I'd greatly
appreciate that...

Thanks,
Devangi.