You could put your code in an Addin.

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

http://support.microsoft.com/?id=211563
How to create an add-in file in Excel 2000

--
Regards,
Tom Ogilvy


"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:578d296c3fdf7@uwe...
Hi experts,

I have a question on using data in excel.

I have an application which holds a lot of sheets. 2 of the sheets, i use
as
database (one to save data of a company in and one to save data of the
employees of that company)

on the other sheets i do a lot of calculations with the data in the two
data
sheets.

When i make a new version of the application, my problem is that the users
simply override the old version with the new version. All data from the
two
data sheets is then lost.

Question:

Can i seperate the application from the database (using excel or access ?)
and how do i go about that and be able to use the data in excel again?

Thanks for replying !!!
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1