Auto save data in xls...

  • Thread starter Thread starter bruness
  • Start date Start date
B

bruness

Hi.
Is there a way to do this?

Hi have a xls work, which i have my last Update to it like this

-|------A------|----B----------
1| Last Update:| 29-01-2004
2|-------------|--------------

In cell B1 i introduce the date manually.
It there any way when i save the work this will be made automatically
 
Hi

I’m not sure if this will work in all versions of excel, but it work
in mine.

You can add a workbook event procedure to change the value of the cel
with the date in it every time you save your workbook.

Name the cell that you want to update as “updates”, then copy this cod
into the event procedures for your workbook.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel A
Boolean)
Range("updates").Value = Now()
End Sub

To view the event procedures, minimise your workbook, right click o
the title bar and click on ‘view code
 
Back
Top