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

kuraitori,

I am not sure, but this may help.
Timezone Calculating Formula
http://www.mrexcel.com/forum/showthread.php?t=300163


Or, you could search on Google for "Timezone Calculating Formula".


Have a great day,
Stan

Chip Pearson has a whole page on this & related subjects. Thre's a downloadable workbook.

Using the functions in the workbook this will retun GMT time

Sub getGMT()
MsgBox Now + GMTBias()
End Sub