Create and distribute add-in
in [Word VBA]
|
Prev: Word form - hidden rows appear when form is clicked
Next: Word VBA code runs fine under XP but does not in Server 2008 VDI
From: Libby on 14 Jan 2010 18:28 Hi there, I have some useful code in my normal template which I would like to convert to an add-in and distribute to colleagues. Users are a mix of Word 2003 and 2007. Any help much appreciated. Libby
From: Jay Freedman on 14 Jan 2010 21:08 For general advice, see http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm. The act that makes an add-in is to store a template in Word's Startup folder. The default location of that folder is the hidden folder %appdata%\Microsoft\Word\Startup. There are a few differences between Word 2003 and Word 2007 that could cause problems for a macro that needs to work in both versions. The main ones are Building Blocks (Word 2007 only) and CommandBar manipulations (some of which are Word 2003 only). Test your macros in both versions to make sure they don't malfunction. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Thu, 14 Jan 2010 15:28:01 -0800, Libby <Libby(a)discussions.microsoft.com> wrote: >Hi there, > >I have some useful code in my normal template which I would like to convert >to an add-in and distribute to colleagues. > >Users are a mix of Word 2003 and 2007. > >Any help much appreciated. > >Libby
From: Fumei2 via OfficeKB.com on 18 Jan 2010 16:23
"The act that makes an add-in is to store a template in Word's Startup folder. " Technically, this is not correct. The act that makes an add-in is to load it as an add-in. An add-in (.DOT) file can be anywhere, and can be loaded (and unloaded) dynamcially. Having it in Startup merely means it is loaded...on Startup. We have a wee .DOT in all our users Startup (thus is loaded on startup), and all it does it put a button on a toolbar that loads/unloads (toggles in and out) another add-in that is on a network drive. That way the real code container (add-in) is in ONE location on a network drive (thus not dependent on the user machine), and can be maintained as ONE file - rather than many many .DOT files in users' Startup. Jay Freedman wrote: >For general advice, see >http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm. > >The act that makes an add-in is to store a template in Word's Startup >folder. The default location of that folder is the hidden folder >%appdata%\Microsoft\Word\Startup. > >There are a few differences between Word 2003 and Word 2007 that could >cause problems for a macro that needs to work in both versions. The >main ones are Building Blocks (Word 2007 only) and CommandBar >manipulations (some of which are Word 2003 only). Test your macros in >both versions to make sure they don't malfunction. > >-- >Regards, >Jay Freedman >Microsoft Word MVP FAQ: http://word.mvps.org >Email cannot be acknowledged; please post all follow-ups to the >newsgroup so all may benefit. > >>Hi there, >> >[quoted text clipped - 6 lines] >> >>Libby -- Message posted via http://www.officekb.com |