How can I manage office macro code? Do I create an add-in?

[Dave Lum]

I have some macros written in office that I need to manage.

The macros access a set of similar databases and create several word and
excel documents from the data there. The problem is that the code is embedded
in a document. There is no revision control, just another document. We create
a new document each time we modify the macro. We have too many documents.

What is the best way to extract this code from the document(s), and package
it into a set of utilites so that we can manage the code? Should I create an
add-in for this?

[Doug Robbins - Word MVP]

The document that contains the macros, (probably with all of the text
deleted from it) should be saved as a template (.dot or .dotm in 2007) in
the Word Startup folder.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Post by Dave Lum
I have some macros written in office that I need to manage.
The macros access a set of similar databases and create several word and
excel documents from the data there. The problem is that the code is embedded
in a document. There is no revision control, just another document. We create
a new document each time we modify the macro. We have too many documents.
What is the best way to extract this code from the document(s), and package
it into a set of utilites so that we can manage the code? Should I create an
add-in for this?

[Jonathan West]

Post by Dave Lum
I have some macros written in office that I need to manage.
The macros access a set of similar databases and create several word and
excel documents from the data there. The problem is that the code is embedded
in a document. There is no revision control, just another document. We create
a new document each time we modify the macro. We have too many documents.
What is the best way to extract this code from the document(s), and package
it into a set of utilites so that we can manage the code? Should I create an
add-in for this?

Take a look here

Distributing macros to other users
http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

Once you've read that, if you have further questions, feel free to post back
here with them.