Opening a template from vba

[Santiago Torras]

How can I open a template from VBA (and get its associated vba code executed)?

I want to create a new document, based on that template, all this from vba
code....

 

[Jezebel]

Documents.Add Template:="C:\....\MyTemplate.dot"

 

[Jeffery B Paarsa]

How can I open this Template but do not execute AutoNew macro but execute a
subroutine for populating fields that I already have collected. I don't want
the UserForm1 to be displayed to the user just execute a sub within the new
doc for populating the already collected info.

 

[Russ]

Jeff,
It might be easier to duplicate your needed template and delete the portions
you don't want, such as the AutoNew subroutine. Then attach that new
template to have the subroutines available that you require.