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 (IP
Address) created a excel document?

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

Thanks


--
Fuabr84
------------------------------------------------------------------------
Fuabr84's Profile: http://www.excelforum.com/member.php...o&userid=33147
View this thread: http://www.excelforum.com/showthread...hreadid=529581

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.
--
Kevin Backmann


"Fuabr84" wrote:


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 (IP
Address) created a excel document?

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

Thanks


--
Fuabr84
------------------------------------------------------------------------
Fuabr84's Profile: http://www.excelforum.com/member.php...o&userid=33147
View this thread: http://www.excelforum.com/showthread...hreadid=529581

hi,
on the tool bar click fileproperties.
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

"Fuabr84" wrote:


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 (IP
Address) created a excel document?

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

Thanks


--
Fuabr84
------------------------------------------------------------------------
Fuabr84's Profile: http://www.excelforum.com/member.php...o&userid=33147
View this thread: http://www.excelforum.com/showthread...hreadid=529581

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


"Fuabr84" wrote:


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 (IP
Address) created a excel document?

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

Thanks


--
Fuabr84
------------------------------------------------------------------------
Fuabr84's Profile: http://www.excelforum.com/member.php...o&userid=33147
View this thread: http://www.excelforum.com/showthread...hreadid=529581