Thread: How to get Timezone in VBA (for Excel)?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Devangi Gandhi Devangi Gandhi is offline
external usenet poster
  
Posts: 2
Default 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 With QuoteReply With Quote