Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Distributed Excel Application
Hi,
I have a failry simple application written in Excel. A few forms, modules, functions etc. Basically it provides a means for users to collect data in a controlled stand alone manner. While the application itself is failry easy to deploy as an XLS file and the end users can happily use it. I have been pondering how I could deploy the application in a way that if I needed to update the application in the future I could do this without affecting or needing to move the underlying data. eg someting like an add-in (but it isn't really an add-in - aqlthough ahppy for ideas). In essence it would be like a database that has the application and the data seperated as a front/back end, although I am trying to avoid having to use two workbooks to achieve this as I don't want to complicate things for the users. Any thoughts or ideas or examples of how this can or has been done. Much appreciated. Jason. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Distributed Excel Application
Two workbooks shouldn't confuse your users, there is no reason that they
would know, it would be a design issue. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jason" wrote in message oups.com... Hi, I have a failry simple application written in Excel. A few forms, modules, functions etc. Basically it provides a means for users to collect data in a controlled stand alone manner. While the application itself is failry easy to deploy as an XLS file and the end users can happily use it. I have been pondering how I could deploy the application in a way that if I needed to update the application in the future I could do this without affecting or needing to move the underlying data. eg someting like an add-in (but it isn't really an add-in - aqlthough ahppy for ideas). In essence it would be like a database that has the application and the data seperated as a front/back end, although I am trying to avoid having to use two workbooks to achieve this as I don't want to complicate things for the users. Any thoughts or ideas or examples of how this can or has been done. Much appreciated. Jason. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distributed Excel Application | Excel Discussion (Misc queries) | |||
Distributed retrival | Excel Worksheet Functions | |||
macro to close excel application other than application.quit | Excel Programming | |||
Updating distributed Excel applications | Excel Programming | |||
Distributed Spreadsheets | Excel Programming |