i have the following problem:

I built an application that uses two sheets for database purposes.
The application is distributed through to many collegues.

When i update the application, all data in the databases will be lost because
i just save the new application over the old one. I would like to be able to
update the application and leave the database intact.

my questions
- Is it possible to do that by making two workbooks like 1 workbook for the
application and one for the database ?
- is it possible to save to a database workbook that is not opened ?
- is it possible to retrieve data form a database workbook that is not opened

- is there some way of making it one file consisting of two workbooks?

Ik hope somebody has the answers for me.

Message posted via OfficeKB.com