View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
prahz prahz is offline
external usenet poster
 
Posts: 18
Default Return System Time Zone

I am creating an application that will be used by users in both the US
and India.

There is a cell in my worksheet that I want the Current Date, the
Current Time, and Time Zone of the user to output to.
-For example, in cell A3, I want the macro to output 12/8/06 4:05PM
(CST). I know how to get the current system date and time (using the
Now function), but how do I return the system time zone?