Perhaps a better way would be to have the spreadsheet auto-save when new data
is entered in it. Then it wouldn't really matter if they closed it or not.
You could open it read-only and get the data out. To do this you could set
up a counter that counts entries, read that # when you first open the
spreadsheet and when it changes initiate a save routine.

An even better solution would be to write the data to an external
data-source like an access file. Then you wouldn't care if they were in the
spreadsheet or not because you would read the data out of access (or you
could read it in excel but it would be stored in Access). There are examples
for doing this on this discussion gruop, or I could set it up for you.