View Single Post
  #5   Report Post  
Russell Burnett Russell Burnett is offline
Junior Member
 
Posts: 2
Default

Hi Rick,

Clearly the date can be manipulated, however, is the date in the statistics tab the ACTUAL CREATION date? Therefore, if no manipulation occured, can I safely say that a file with a Creation Date of say 02/02/2010 could not have been created any earlier than 02/02/2010 regardless of how many times it was saved with a new name or onto a new storage medium.

Thanks

Russell


Quote:
Originally Posted by Rick Rothstein View Post
If you are talking about the file's date as it shows up in Windows Explorer,
then yes, the creation and/or modified dates can be changed by running a
relatively easy to construct program in any one of a number of programming
languages. As these programs would change the date on the hard disk, there
would be no forensic way (that I am aware of) to determine such a
manipulation was done. Here is but one website (of the many out there)
showing how to do this in the compiled version of VB (I didn't look at it in
detail, but I would be willing to bet it could be modified to run in VBA
within Excel in order to accomplish the same thing)...

http://vbnet.mvps.org/index.html?cod...ledatetime.htm

If you are talking about the statistics Excel tracks within its Properties
for the workbook, I'm afraid that is easy to change as well...

http://www.mrexcel.com/forum/showthread.php?t=32908

--
Rick (MVP - Excel)


"indians777" wrote in message
...
Is it possible to change the creation/modified dates in Excel?

Example...

Can someone change their computer date and create an excel file so that it
would appear that it was created say 3 years ago? Is there someway of
finding out if a person did this? We have a potential legal battle and we
believe that this is being done to tamper with documents already created.