Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setup project for Excel addin, won't register addin | Excel Programming | |||
Removing an Addin from the Tools Addin list. | Excel Programming | |||
Unshimmed Automation Addin and Shimmed COM Addin in same App Domai | Excel Programming | |||
Distribute Excel Addin | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming |