Getting back the same document we sent.

  • Thread starter Thread starter Bob Day
  • Start date Start date
B

Bob Day

Using Excel 2003...

Monthly, we send excel spread sheets to clients who edit them and then send
them back. Unfortunately, buy the time they send them back, they have
usually renamed them. We are always worried that that are sending back an
older excel spread sheet that they have worked on.

It there any way to confirm the excel spread sheet we are getting back is
the one se sent them (i.e. the most recent one?). It would have to be
something they cannot edit, so merely adding a date cell or something like
that would not work (unless you could lock only that cell without protecting
the entire spread sheet, which I don't see how to do).

Any ideas?
Thanks
Bob
 
Hi

You could write a version number and date on another sheet, then Hide
the sheet.
Probably unlikely the client would Unhide the sheet and change the data
then Hide again.
 
Perhaps a formula in a cell that creates a hash code of some unique cell
contents of the particular sheet. If they over write that the change
should be apparent.
 
Bob:

You might want to look in VBA Help and google the excel.programming
newsgroup for CustomDocumentProperties. You can add a value into the
Properties of your workbook that can be checked - if it's not there,
you've got a different workbook instead of an updated workbook.

Ed
 
Back
Top