Hello All,
What is the best way to distribute my VBA Add-In to everyone in the office?
Ideally, I would like a process whereby the Add-In could automatically be installed in the default directory for Add-Ins.
In a perfect world, I would like a process whereby it installs in the default directory, but I have the ability to distribute updates as well.
Anyone have knowledge about distribution?
Put it on a network share (that makes it accessible to all) and make it read-only (which prevents Excel from locking the file, and therefore allows you to make updates).
Entia non sunt multiplicanda sine necessitate
For a more verbose version of shg's answer: http://www.excelguru.ca/content.php?...rk-Environment
Remember what the dormouse said
Feed your head
How do I make the file Read Only, and how do I make the update? Replace the file or make it non read only, edit, and save?
Right-click, Properties, ...How do I make the file Read Only,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks