Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make Lable in Excel from a xls file | Excel Discussion (Misc queries) | |||
How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file? | Excel Programming | |||
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions | |||
How to make one CSV file from two Excel sheets? | Excel Discussion (Misc queries) | |||
How to I make a back up file in excel. | Excel Discussion (Misc queries) |