Results 1 to 4 of 4

Using VBA to get system time in GMT equivalent instead of local time

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-17-2008
    Location
    Vancouver
    MS-Off Ver
    2002 and XP
    Posts
    117

    Using VBA to get system time in GMT equivalent instead of local time

    Hello,
    I am wondering if there is a simple way to get the GMT equivalent in vba code. I am being a date/timestamp but realized that timezone differences may complicate matters, therefore I would like to "standardize" the timestamps into their GMT equivalent rather then using the computer's local time

    I had been using
    textbox1.text = Now
    and am wondering if there is a simple alteration to this that would acheive what I want it to

    thanks in advance
    Last edited by kuraitori; 03-03-2009 at 06:12 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1