PDA

View Full Version : Script to show up time zone in excel



Skopweb
08-24-2009, 02:56 AM
Hello
Is there a possiblility of a script in excel that will show me the time zone to which the system time of the PC is configured

Regards
Skopweb

mdmackillop
08-24-2009, 05:15 AM
Try a web search for "Time Zone" +VBA and you'll find articles such as this.
http://www.cpearson.com/Excel/TimeZoneAndDaylightTime.aspx

GTO
08-24-2009, 05:17 AM
Oops... slow fingers, same link :-)

Skopweb
08-24-2009, 07:29 AM
Hello Guys
Thanks for the link
but i dont know how to get this started in excel....
i have entered one of the script in Workbook code
but now which cell in excel gives me the data
regards
skopweb