Show Date File was saved

  • Thread starter Thread starter Imry
  • Start date Start date
I

Imry

I need to show in Excel, inside a cell, the date the the
file was last saved.
Is this possible?
 
Hi Imry

You can use this event in the Thisworkbook module

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)If you save the file the date will be placed in cell A1of Sheet1
Sheets("Sheet1").Range("a1").Value = Date
End Sub
 
Oops

This is better

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
'If you save the file the date will be placed in cell A1of Sheet1
Sheets("Sheet1").Range("a1").Value = Date
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
show last date saved in excel 2
displaying the latest save date - 4
Retrieve the date of another excel file 2
Sharing workbook, show last user change? 1
microsoft excel 5
How to put save date in the header (or footer) 10
Numbers change when saving as a csv fle 3

Back
Top