Time zone

K

Karpagam

Hi

I need a help to find timezone from system date using vba
code.

thanks
kalyan
 
K

Karl E. Peterson

Karpagam said:
I need a help to find timezone from system date using vba
code.
Click to expand...

Not sure you can do it from the system date? But you can call the
GetTimeZoneInformation API, which provides a pretty good deal of data to work from.
If you download TimeZone.zip from http://www.mvps.org/vb/samples.htm you'll have a
drop-in ready class you can use in VBA.

Later... Karl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem activating pre-installed MS Office home and Student 0
Include time zone in time stamp? 1
import CSV schedule with different time zone 2
Unable to change items in Calendar that have GMT timezone. 0
Copy previous record into form field 0
Reading Metadata from Word Documents 0
Multiple Time Zone All Day events 1
Word vba 0

Top