oh dear.. we have a true researcher...

the site mentioned has a few more pages on the subject...
http://vbnet.mvps.org/index.html?cod...zonechange.htm

does EXACTLY what your want. enumerating and decoding the entire hive.

the only thing you need to do is tell your notepad which timezone the
current hotelroom is...




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"?B?TmlsZV9IZWY=?=" wrote:

I hadn't seen Chip Pearson's collaboration with his fellow-MVP's on
the topic of Time Zones, and that particular use of
GetTimeZoneInformation is an interesting extension of Chip's own
article at http://www.cpearson.com/excel/timezone.htm

Nevertheless, both articles share the same limitation: the only time
zone identifier you can feed the function is 'This' time zone. I can't
run a computer in London or Hong Kong and pass the parameter 'EST' or
equivalent, expecting the function to return the TZI record with
names, offsets and bias for Eastern Standard Time.

So we're still looking at creating and populating our own hardcoded
lists, rather than extracting the information which we know is in the
operating system. Somewhere.