Running Clock VBA has date as 1900-01-00 need to be today.

There are three VBA functions -- Time which returns the current time of day (without date information).
Date which returns the current day without time of day information.
Now which returns both date and time information.

I would replace your use of Time with Now in the statement that writes the current date/time to D2. The other thing I would do is write the data to Excel as a double rather than a text string to avoid any mistakes Excel might make in interpreting date/time text strings. Instead of Format(), I would use CDbl()

Please Login or Register  to view this content.

Does that work better?