The following line of code will not work with Excel'97 but will work on
later versions (goes into Debug - Invalid procedure)

Sheets("Access Log").Cells(x + 2, 1) = Format(Now(), "ddd dd/mm/yy at
hh:mm:ss ampm ")

Does anyone know code for above formatting that will work with Excel'97 and
above?


Thanks