Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Time Stamp at the end of a VBA Mac

Comment:

I need to put a time stamp in a excel workbook, i tried Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+; which does give a timestamp, but when it is recorded into a macro, it records the date and time i recorded the macro and not when the macro ran.

Name: rhawk7938
Date: May 5, 2005 at 17:53:52 Pacific

Reply:

I solved the problem with VB code. It only puts the date in if the cell is empty. If it's not empty that means the original date is already there. ThisDate = FormatDateTime(Date, 2) currentdate = Range("B5") If IsEmpty(currentdate) Then Range("B5") = ThisDate Hope this helps.

0

Word Document just hangs

Clip organizer cannot com...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Writing a Word macro which edits a Winamp play list into a listing for a CD label. I would like the macro to know when it reaches the end of the list so that it can finish. Currently I enter the num...

Summary: This should help you see the light at the end of your carpel tunnel: Paste your links as HTML into a spreadsheet, select them and run this code. It should put the URL for each link in the next column....

Summary: Hi Boris, your e-mail is most likely time stamped at the time it was received at your ISP's server not when you download it. Check it out by sending yourself an e-mail, wait 15- 30 min. and then down...