Excel uses the local time and terefore you need to use system calls to get
the information.

Chip Pearson (http://www.cpearson.com) has a good description with examples
of using time zones at http://www.cpearson.com/excel/timezone.htm

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"prahz" wrote:

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?