Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel userform save problem
Hi,
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. Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200510/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel userform save problem
You should put your code in an addin.
So yes, separating your code from the data is the solution. 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 http://msdn.microsoft.com/library/en...xceladdins.asp http://msdn.microsoft.com/library/en...vrcreatingexce... http://www.j-walk.com/ss/excel/tips/tip45.htm Excel 97: Creating Add-Ins http://support.microsoft.com/?id=167909 XL: Securing Visual Basic Code in Microsoft Excel -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:564483a1dc6c4@uwe... Hi, 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. Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200510/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel userform save problem
Hi Tom,
Thanks for your suggestions...as always ! But... - My application is hidden. - The user only sees the userform. - in the application i have a 2 database sheets called 'database' and 'dbasedlnrs'. Now, when i update the apllication because i have a newer and better (hopefully) version, all data is lost in the database and dbasedlnrs sheets because i just copy the new application file over the old file. Therefore i though it might be an idea to seperate the database sheet from the application, but i don not know how.... Would it be possible to make the database sheets an addin that is loaded with the application and if this is possible, how o i go about this ? Thanks Tom Pierre Tom Ogilvy wrote: You should put your code in an addin. So yes, separating your code from the data is the solution. 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 http://msdn.microsoft.com/library/en...xceladdins.asp http://msdn.microsoft.com/library/en...vrcreatingexce... http://www.j-walk.com/ss/excel/tips/tip45.htm Excel 97: Creating Add-Ins http://support.microsoft.com/?id=167909 XL: Securing Visual Basic Code in Microsoft Excel Hi, [quoted text clipped - 19 lines] Thanks, Pierre -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel userform save problem
Put the database sheets in one workbook
Put all you code and useform in another workbook and make that an addin (or not - your choice) Have the code refer to the worksheets in the database workbook rather than in the addin itself. If the database is hidden, then you can still refer to it by fully qualifying your code LastRow = Workbooks("Database.xls").Worksheets( _ "Sheet3").Cells(Rows.count,1).end(xlup).row will work fine as long as Database.xls is open - it doesn't have to be visible. this will allow you to just overwrite the workbook with the code and the database workbook will remain untouched. -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:5653b1d8f6d6d@uwe... Hi Tom, Thanks for your suggestions...as always ! But... - My application is hidden. - The user only sees the userform. - in the application i have a 2 database sheets called 'database' and 'dbasedlnrs'. Now, when i update the apllication because i have a newer and better (hopefully) version, all data is lost in the database and dbasedlnrs sheets because i just copy the new application file over the old file. Therefore i though it might be an idea to seperate the database sheet from the application, but i don not know how.... Would it be possible to make the database sheets an addin that is loaded with the application and if this is possible, how o i go about this ? Thanks Tom Pierre Tom Ogilvy wrote: You should put your code in an addin. So yes, separating your code from the data is the solution. 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 http://msdn.microsoft.com/library/en...xceladdins.asp http://msdn.microsoft.com/library/en...vrcreatingexce... http://www.j-walk.com/ss/excel/tips/tip45.htm Excel 97: Creating Add-Ins http://support.microsoft.com/?id=167909 XL: Securing Visual Basic Code in Microsoft Excel Hi, [quoted text clipped - 19 lines] Thanks, Pierre -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA - Userform updation/deletion problem | Excel Programming | |||
Excel VBA - Userform Texbox/Scrollbar problem | Excel Programming | |||
Excel VBA - Userform combox problem | Excel Programming | |||
excel vba- userform problem | Excel Programming | |||
excel VBA - Userform cmd problem | Excel Programming |