Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to distribute updated code of a addin to users?
I have a addin used by several users. One of the sheet in addin is
used for recording data. Now I have added some more functions and want to distribute the same to users. I can not ask users to just replace addin file coz it will affect the existing records. Also only one or two module is updated and rest of the module and forms are same. Problem here is that users are not experts and may goofeup. Is there any way I can do it automatically? Or any other better way? Regards, Madiya. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to distribute updated code of a addin to users?
Hi Madiya,
One way would be to write some code in another book that updates the code in your addin. You could then just assign that to the Workbook_Open event of the new book so that all you have to do is send it to the users, they open it and close it and all is done. Actually you could also make it close itself even (remember to programatically save the addin). info can be found he http://j-walk.com/ss/excel/tips/tip61.htm Cheers, Ivan. On Mar 27, 6:06*pm, Madiya wrote: I have a addin used by several users. One of the sheet in addin is used for recording data. Now I have added some more functions and want to distribute the same to users. I can not ask users to just replace addin file coz it will affect the existing records. Also only one or two module is updated and rest of the module and forms are same. Problem here is that users are not experts and may goofeup. Is there any way I can do it automatically? Or any other better way? Regards, Madiya. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to distribute updated code of a addin to users?
Just another note...
If you do go down this path, be aware that all installations of Office since 97 (I think) will ban this by default, so you would have to also provide users with instructions on how to temporarily disable the security and then re-enable it (it would be a major security risk if left open). See this KB article for more info: http://support.microsoft.com/kb/q282830/ Cheers, On Mar 27, 6:49*pm, Ivyleaf wrote: Hi Madiya, One way would be to write some code in another book that updates the code in your addin. You could then just assign that to the Workbook_Open event of the new book so that all you have to do is send it to the users, they open it and close it and all is done. Actually you could also make it close itself even (remember to programatically save the addin). info can be found hehttp://j-walk.com/ss/excel/tips/tip61.htm Cheers, Ivan. On Mar 27, 6:06*pm, Madiya wrote: I have a addin used by several users. One of the sheet in addin is used for recording data. Now I have added some more functions and want to distribute the same to users. I can not ask users to just replace addin file coz it will affect the existing records. Also only one or two module is updated and rest of the module and forms are same. Problem here is that users are not experts and may goofeup. Is there any way I can do it automatically? Or any other better way? Regards, Madiya.- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to distribute updated code of a addin to users?
You have made the cardinal sin, you have merged the business logic and the
data into a single workbook. You should separate them, then any updates to your addin are easily implemented. I would suggest that you bite the bullet, break the application up, and visit every user and break the data out. It will be time consuming to start, but it will pay dividends in the future. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Madiya" wrote in message ... I have a addin used by several users. One of the sheet in addin is used for recording data. Now I have added some more functions and want to distribute the same to users. I can not ask users to just replace addin file coz it will affect the existing records. Also only one or two module is updated and rest of the module and forms are same. Problem here is that users are not experts and may goofeup. Is there any way I can do it automatically? Or any other better way? Regards, Madiya. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distribute Addin | Excel Programming | |||
Distribute Add-In as Machine Code Only? | Excel Programming | |||
Distribute Toolbar to other users | Excel Programming | |||
Distribute Excel Addin | Excel Programming | |||
How to distribute Control files (OCX) to users? | Excel Programming |