Origin Of a Spreadsheet

[Fuabr84]

Hi

Does ANYONE know if it is possible to find the origin of a spreadsheet
By this i mean is it possible to track who(Computer Name) or what PC (I
Address) created a excel document?

For example say Bob created a Excel document but i dont know he did bu
i need to find out... How do i find out Bob Created it? Is it possible?

Thank

 

[Guest]

You can check the document properties by clicking on FILE and selecting
PROPERTIES. This might have the information you need regarding the
originator of the work sheet.

 

[Guest]

hi,
on the tool bar click file>properties.
it may not give you the infomation you listed below but it should give to
the logon name of the author, last saved by, date created, date last
modified, ect.
there is alot of other info there but it has to be filled in manually and
most people don't bother with that.

Good luck

FSt1

 

[Guest]

If you are not against using code, here is a macro that pastes the author and
creation date.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = _
ThisWorkbook.BuiltinDocumentProperties("Author")
Sheets("Sheet1").Range("A2").Value = _
ThisWorkbook.BuiltinDocumentProperties("Creation Date")
End Sub