Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel and database question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel and database question
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel and database question
Hi Tom,
You've got to help me a little bit more please.... I read the link you posted and now i know how to make an addin but... - how can i acces the addin form my application ? - is the addin automatically loaded when i start my application ? - how does it actually work ? Thanks for yor help...as always ! Pierre Tom Ogilvy wrote: 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 Hi experts, [quoted text clipped - 18 lines] Thanks for replying !!! Pierre -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database Question? | Excel Discussion (Misc queries) | |||
HELP!! excel database question | Excel Discussion (Misc queries) | |||
Excel as Database - Pivot Question | Excel Discussion (Misc queries) | |||
Database question | Excel Programming | |||
Database question | Excel Programming |