How many times this file edited

[Prem Soni]

Hi All,

Can anybody tell me is there any way through that i can set a formula or
programming in excel file to get it know that "how many times this file
edited" and when it last modified?

Pls help me out if someone knows...

Prem Soni

 

[Gary''s Student]

Put the following in the workbook code area:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Activate
Set r1 = Range("A1")
Set r2 = Range("A2")
r1.Value = r1.Value + 1
r2.Value = Date
End Sub

I assume that "edited" means "changed and saved"

 

[Prem Soni]

Hi Gary!

Thanks its working.

Now pls let me know this also how can i set this "How many Times this file
saved or modified" to 0 (zero)
I mean can i reset this value. I think u got what i want?

Prem Soni

 

[Les]

Hello Prem, you just change the number in the cell A1 to zero (0)

 

[Prem Soni]

Its working !

Thanks Les

Hello Prem, you just change the number in the cell A1 to zero (0)