Opening a template from vba

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Santiago Torras - 04 Sep 2006 01:40 GMT

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....

Signature

thanks

Reply to this Message

Jezebel - 04 Sep 2006 02:29 GMT

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

> 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....

Reply to this Message

Jeffery B Paarsa - 13 Sep 2006 00:01 GMT

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.

Signature

Jeff B Paarsa

> Documents.Add Template:="C:\....\MyTemplate.dot"
>
[quoted text clipped - 3 lines]
> > I want to create a new document, based on that template, all this from vba
> > code....

Reply to this Message

Russ - 01 Oct 2006 08:07 GMT

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.

> 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
[quoted text clipped - 8 lines]
>>> I want to create a new document, based on that template, all this from vba
>>> code....

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Reply to this Message