Last saved option?

[Andy Moore]

Hi,

Can anyone advise how to set up a sheet that links in the last saved date and or time of a certain spreadsheet?

Regards,

Andy

 

[Sektor]

Can you explain in more detail?
You want just to store some value?

 

[Andy Moore]

Hi,

Sorry to be brief. Its basically that I need to link into spreadsheet A the last saved time or date that several other spreadsheets were saved B, C, D etc.

Many thanks for reading

 

[Sektor]

What do you mean "save time of spreadsheet"? Does such thing exist?

 

[Andy Moore]

So sorry - what I need is the time or date that a certain spreadsheet was saved that can be somehow linked into another spreadsheet. So if I appear a bit vague!

Regards

Andy

 

[Sektor]

I am sorry, Andy, but there's no such thing as "save time of sheet". The only thing I can offer you is to track "Workbook_BeforeSave" event and check which sheet was active. Knowing the active sheet, you can write down time to your cell. Here's example:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

    With Sheets("A").Cells(.Rows.Count, "A").End(xlUp)
        .Value = ActiveSheet.Name
        .Offset(, 1) = Now
    End With

End Sub

 

[Andy Moore]

Nice one. Many thanks for this.

Regards,

Andy