VBA code in other template to update Normal.dot VBA code

[Ben]

Hi

Is there any way to write a macro in another template to extract a sub from
a VBA module in the normal.dot and then update it from another macro?

Any advice would be much apprecitated

Thanks
B

 

[Chip Pearson]

See www.cpearson.com/excel/vbe.htm for details about using code
to manipulate VBA code. It's written for Excel, but most of
what's there will work in any application that supports VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Jonathan West]

Hi

Is there any way to write a macro in another template to extract a sub
from
a VBA module in the normal.dot and then update it from another macro?

Any advice would be much apprecitated

I'm sure Chip's advice will work if you decide to go this way, but could I
counsel against trying to modify people's normal.dot templates for the
following reasons:

1. normal.dot is the user's individual customisation scratchpad. Make
unexpected changes to it and you may have a riot on your hands from your
users.

2. normal.dot is the user's individual customisation scratchpad. You have no
guarantee that the user won't go & accidentally or deliberately undo your
changes.

3. normal.dot is the user's individual customisation scratchpad. It is
easily corrupted and can stop working.

Take a look here for an alternative approach.

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

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org