View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Make sure that the excel file is still the same

Maybe you could save the file with a password to modify:
Under the file|SaveAs|tools menu.

Then not share that password with anyone who shouldn't have access to change the
file.

"Jörgen Ahrens" wrote:

We have a simple excel-file. We create a copy of it and just open it up with
excel and close it without changing or saving anything. If you then use a
binary compare to compare the two files you see differences...and for that
we could not use the hash value.
we would like to know if the file we open is still the same when we last
opened it...and therefore we tought about a hash value...but its not going
to work if the file changes even if there is nothing changed inside...

we already have an id as a custom Propertie field in the file itself (to
uniqly identify the file), but we would like to have more control over it
(its easy for a customer to change the custom propertie field) so we thought
about a hashvalue...

do you know of any other way to do that?

thanks for your reply.

"K Dales" wrote in message
...
Upon rereading, I am not sure I understood correctly with my first reply.
That reply assumed you wanted to know if an open workbook had been saved.
Are you wanting to know this for a closed workbook file? If so, what
could
have changed it since it was last saved?
--
- K Dales


"Jörgen Ahrens" wrote:

Hi All

Is there a good way to test if the excel file hasn't been changed since
it
was last saved?

We thought about computing the hashvalue but we noticed that when the
excel
file is opened and closed without changing anything it changes its last
access date/time and also something inside the datastructure of the file.
that destroyes our hashvalue theory...

thanks for your help.




--

Dave Peterson