Create and distribute add-in

[Libby]

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

 

[Jay Freedman]

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
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Fumei2 via OfficeKB.com]

"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

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
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

Hi there,

[quoted text clipped - 6 lines]

Libby