I have prepared a Excel module composed of 1 front page that the user
get access to and where the user can update the data, all of the date
is then collated and reorganised on 2 other files one is a database
that keeps the records in the correct order and the other is the one
where the records are read from and written to before being stored on
the database. the whole thing is done on VBA code and Macros, the
access the user has is limited to the 6 buttons 1 combobox and 3 cells
(1 text and 2 numerical). The problem that I have is that the on
closing the program sometimes it crashes and one of the files doesn't
get saved but it becomes a number, how can I resolve the bug?