How do I insert a last saved date field

you might be able to use/modify this. you will need to have a 'log' sheet

Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
(ByVal lpBuffer As String, _
nSize As Long) As Long


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

On Error GoTo carryon
Application.ScreenUpdating = False
Dim lpBuff As String * 25
Dim ret As Long, UserName As String
ret = GetUserName(lpBuff, 25)
UserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)
Sheets("log").Activate
lastrow = [a1].CurrentRegion.Rows.Count
'add username date and time
Sheets("log").Cells(lastrow + 1, 1).Value = Application.UserName
Sheets("log").Cells(lastrow + 1, 2).Value = Date
Sheets("log").Cells(lastrow + 1, 2).NumberFormat = "mmmm d, yyyy"
Sheets("log").Cells(lastrow + 1, 3).Value = Time
Sheets("log").Cells(lastrow + 1, 4).Value = UserName
Application.ScreenUpdating = True
ActiveWorkbook.Saved = True
carryon:
End Sub

ermm
I haven't got a clue what you're talking about, I was expecting a simple answer
Sorry, I am not an excel expert, this is just a basic document, so if you could make it any clearer I would appreciate it! I am using Excel '97 in windows 98

Malc

If you want it really simple, here's how to do a very simple version.

You'll need either a separate info sheet in your book, or a couple of cells somewhere that they aren't going to be overwritten.

I named the 2 cells "mod_opr" and "mod_tme". You can name them whatever you wish.

Hit Alt-f11 to open the VB editor

On the LHS double click on the "ThisWorkbook" and copy this into it.


I am assuming that you don't have macros in this already.

I hope this helps.

Cheers

Barry

edit: damned typos.

I got the following message:

Run time error '1004':

Method 'Range' of object'_Global' failed

I then tried it again with "mod_opr" and "mod_tme" (including the speech marks) Same thing happened. I clicked Debug, but to be honest I don't really know what I am doing here! (straight over my head).

Does it matter which cell I am in when I go to the VB editor? I was in an empty one.

Sorry to be so dumb, but we all have to start somewhere

Malc

That's alright. No need to apologise. Like you said, we all start somewhere.

It looks like you haven't named your cells.

Go to the cell that you want to name "mod_opr". There's a little box in the top left that will have an address like "C1" (or whatever the active cell is).

Click in that box, and type in "mod_opr" (wihtout the exclamation marks).

Repeat for the cell you want "mod_tme" to be in.

Your macro should now work.

If you have any problems, feel free to email me the sheet (but do me a favour and zip it first).

Cheers

yay!!! it works!

Thank you very much Mr Walker, I guess it's easy when you know how! :D

Malc

I know this is a super-old thread, but just in case someone else is googling for this (like I was today)... Found another thread that provided a much simpler answer, which works a treat. See here: http://www.mrexcel.com/forum/excel-questions/423192-date-last-saved-modified.html