Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get Timezone in VBA (for Excel)?
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get Timezone in VBA (for Excel)?
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 "Devangi Gandhi" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get Timezone in VBA (for Excel)?
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. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timezone converter | Excel Worksheet Functions | |||
How do I convert GMT date/time to different timezone | Excel Worksheet Functions |