Auto save data in xls...

[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

 

[Nicky]

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

 

[bruness]

Please se the file atach.
I'm using Office 2004.
I am not to understand what I have to make.
Please helpe me

Attachment filename: last_update.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=42429

 

[Nicky]

Does this help?

Attachment filename: file.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=424346

 

[bruness]

Yes it help.
Thanks a lot