Word VBA; Document to inherit code from template

[BrianWen]

I have a template with a bunch of vba scripts and I'd like that a document made from the template inherits a certain script.

How would I go about that? - There must be some code to 'copy' a module or something like that.

Thanks in advance!

 

[macropod]

Hi Brien,

You can do that by first exporting the code module from the template, then adding the following code to the template's 'This Document' module:

Private Sub Document_New()
Dim InFile As String
InFile = "C:\Users\Brien Wen\My Documents\Templates\CodeModule.bas"
If Dir(InFile) = "" Then Exit Sub
Application.VBE.ActiveVBProject.VBComponents.Import (InFile)
End Sub

Change the path & filename to match wherever you store the code module. If you need the solution to be portable, you can add code to do the export also (to, say the template's own folder) every time a new file is created and, after importing into the new document, delete the exported module.


Cheers
[MS MVP - Word]

 

[BrianWen]

Thank you for the answer. I will look into it and get back...