Timestamp at the end of a vba code

[jimmyvba]

Hi Guys,

I run a vba code everyday to update my reports. I would like to add a few lines to the code so that I can publish the time when it was run. This will basically help others who have access to the file to know when the report were last updated.

Any pointers? Thanks in advance.

Cheers.

 

[wrightyrx7]

How about recording the date on a hidden sheet then a message box pop up when the workbook is open to notify the person of the date it was last run?

 

[jimmyvba]

I would want the code to print the time it was run on a cell. I have multiple macro buttons on a single sheet. So basically, my goal is that below each of the buttons, people will be able to see when exactly it was last run.

 

[jimmyvba]

Problem solved..I just added a line at the end making a cell = Now(). That does the job. Thanks.

 

[jimmyvba]

Extremely sorry. The problem is still there. Making a cell = NOW() doesn't work as it keeps on updating irrespective of the macro. Still looking for pointers.

 

[slinky]

activecell.Value = date() &" " & time()

Try that...

 

[wrightyrx7]

Lets say you want this date in cell A1 on Sheet1

At the bottom of each of you macros as this:

Worksheets("Sheet1").Range("A1").Value = Now()

This will put the date in as a VALUE that will only be updated when you run your macro.

 

[jimmyvba]

Hi Guys,

Putting those formula is what I was also doing but the time used to keep on updating on its own. So now I am basically using that formula to find the time at the end of the code and then pasting it as a text onto a cell so that it stops updating from then on.

That does the job.

Thanks for the help.

Cheers.