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

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

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

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