I'm not quite clear on what question is, but you can get the current time in
a formatted string with code like

Dim S As String
S = Format(Now, "dd-mmm-yyyy hh:mm:ss")
Debug.Print S


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Gordo" wrote in message
ups.com...
Hi there,

I'm trying to use the Now() function without accessing a cell in the
spreadsheet. Trying to assign the datetime to a string for a log file,
but I don't want to have to access the worksheet when doing it. Any
ideas?

Cheers