Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last saved by 1

Status
Not open for further replies.
Cage

Cage

MIS
Aug 25, 2002
50
CA
Does anyone know how I can tell who lasted saved a document using VBA?

TIA

Cage
 
Sort by date Sort by votes
Something like this:

Code: 
Sub test()
Dim msg As String
msg = "Last Saved By: "
msg = msg & ThisWorkbook.BuiltinDocumentProperties("Last Author") & vbCrLf
msg = msg & "Date Saved: " & ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
MsgBox msg
End Sub

I hope this helps!



Peace! [peace]

Mike

Never say Never!!!
Nothing is impossible!!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
664
mintjulep
M
feipezi
  • Locked
  • Question
How to detect dups and/or sum by group?
Replies
1
Views
257
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
Hoe to fix run time error 2147217900 (80040e14) syntax error in Order By clause 1
Replies
6
Views
1K
Andrzejek
Andrzejek
arvarr
  • Locked
  • Question
Excel Help - Worksheets by UserID 3
2
Replies
39
Views
931
arvarr
arvarr
IcarusHallsorts
  • Locked
  • Question
Changing a command button by VBA
Replies
8
Views
747
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top