Distribute Addin
Hi there,
I've created an Addin which contains custom forms for routine, but complex things i do. Other people have expressed an interest in having them, but I'm not sure what is the best way to get the addin from my Addins folder to their Addins folder. We have a "menu" type workbook from which it might be possible to have a download feature which could copy it from a stored location to their Addins folder, but it'd need to overwrite the existing file. Any ideas? Cheers x |
Distribute Addin
Do you have a common network drive that can hold the addin?
If yes, then I'd put the addin in that location. Then tell the users to use Tools|Addins to browse for that addin in that common network location. In fact, I'd tell them to use the UNC Path instead of any mapped drive letter. If that's not possible, then I'd tell the users to create a new folder on their C: drive. Name that new folder: C:\LibbyUtils And then just email the addin to them with instructions to save the file into that special folder C:\LibbyUtils. Then tell them to use Tools|Addins to install the addin. (All of this assumes that you're using xl2003 menus.) By storing the addin in a folder with the same name, you'll be avoiding lots of problems of where the macros are. Libby wrote: Hi there, I've created an Addin which contains custom forms for routine, but complex things i do. Other people have expressed an interest in having them, but I'm not sure what is the best way to get the addin from my Addins folder to their Addins folder. We have a "menu" type workbook from which it might be possible to have a download feature which could copy it from a stored location to their Addins folder, but it'd need to overwrite the existing file. Any ideas? Cheers x -- Dave Peterson |
Distribute Addin
Libby,
have a look at this article - may be of some help to you. http://www.vbaexpress.com/forum/show...=10855&garpg=5 -- JB "Libby" wrote: Hi there, I've created an Addin which contains custom forms for routine, but complex things i do. Other people have expressed an interest in having them, but I'm not sure what is the best way to get the addin from my Addins folder to their Addins folder. We have a "menu" type workbook from which it might be possible to have a download feature which could copy it from a stored location to their Addins folder, but it'd need to overwrite the existing file. Any ideas? Cheers x |
Distribute Addin
It's an interesting article and written with good intent. However, at a
glance, some aspects of the code are incorrect or incomplete and may potentially lead to various errors (break) and failure to install as an addin into the addin manager. Another link here http://www.jkp-ads.com/articles/DistributeMacro10.htm and other articles on the same site Regards, Peter T "john" wrote in message ... Libby, have a look at this article - may be of some help to you. http://www.vbaexpress.com/forum/show...=10855&garpg=5 -- JB "Libby" wrote: Hi there, I've created an Addin which contains custom forms for routine, but complex things i do. Other people have expressed an interest in having them, but I'm not sure what is the best way to get the addin from my Addins folder to their Addins folder. We have a "menu" type workbook from which it might be possible to have a download feature which could copy it from a stored location to their Addins folder, but it'd need to overwrite the existing file. Any ideas? Cheers x |
All times are GMT +1. The time now is 07:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com