close

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: www.excelforum.com/member.php...oamp;userid=33147
View this thread: www.excelforum.com/showthread...hreadid=529581You 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 Backmannquot;Fuabr84quot; wrote:

gt;
gt; Hi
gt;
gt; Does ANYONE know if it is possible to find the origin of a spreadsheet?
gt; By this i mean is it possible to track who(Computer Name) or what PC (IP
gt; Address) created a excel document?
gt;
gt; For example say Bob created a Excel document but i dont know he did but
gt; i need to find out... How do i find out Bob Created it? Is it possible?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Fuabr84
gt; ------------------------------------------------------------------------
gt; Fuabr84's Profile: www.excelforum.com/member.php...oamp;userid=33147
gt; View this thread: www.excelforum.com/showthread...hreadid=529581
gt;
gt;

hi,
on the tool bar click filegt;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

quot;Fuabr84quot; wrote:

gt;
gt; Hi
gt;
gt; Does ANYONE know if it is possible to find the origin of a spreadsheet?
gt; By this i mean is it possible to track who(Computer Name) or what PC (IP
gt; Address) created a excel document?
gt;
gt; For example say Bob created a Excel document but i dont know he did but
gt; i need to find out... How do i find out Bob Created it? Is it possible?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Fuabr84
gt; ------------------------------------------------------------------------
gt; Fuabr84's Profile: www.excelforum.com/member.php...oamp;userid=33147
gt; View this thread: www.excelforum.com/showthread...hreadid=529581
gt;
gt;

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(quot;Sheet1quot;).Range(quot;A1quot;).Value = _
ThisWorkbook.BuiltinDocumentProperties(quot;Authorquot;)
Sheets(quot;Sheet1quot;).Range(quot;A2quot;).Value = _
ThisWorkbook.BuiltinDocumentProperties(quot;Creation Datequot;)
End Subquot;Fuabr84quot; wrote:

gt;
gt; Hi
gt;
gt; Does ANYONE know if it is possible to find the origin of a spreadsheet?
gt; By this i mean is it possible to track who(Computer Name) or what PC (IP
gt; Address) created a excel document?
gt;
gt; For example say Bob created a Excel document but i dont know he did but
gt; i need to find out... How do i find out Bob Created it? Is it possible?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Fuabr84
gt; ------------------------------------------------------------------------
gt; Fuabr84's Profile: www.excelforum.com/member.php...oamp;userid=33147
gt; View this thread: www.excelforum.com/showthread...hreadid=529581
gt;
gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()