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

Re: Opening a template from vba by Jezebel

Jezebel
Sun Sep 03 20:29:46 CDT 2006

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



"Santiago Torras" <SantiagoTorras@discussions.microsoft.com> wrote in
message news:399A658D-F6B5-4481-87A9-94684E2D0F10@microsoft.com...
> 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....
> --
> thanks



Re: Opening a template from vba by JeffBPaarsa

JeffBPaarsa
Tue Sep 12 18:01:02 CDT 2006

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.
--
Jeff B Paarsa


"Jezebel" wrote:

> Documents.Add Template:="C:\....\MyTemplate.dot"
>
>
>
> "Santiago Torras" <SantiagoTorras@discussions.microsoft.com> wrote in
> message news:399A658D-F6B5-4481-87A9-94684E2D0F10@microsoft.com...
> > 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....
> > --
> > thanks
>
>
>

Re: Opening a template from vba by Russ

Russ
Sun Oct 01 02:07:06 CDT 2006

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
> the UserForm1 to be displayed to the user just execute a sub within the new
> doc for populating the already collected info.
> --
> Jeff B Paarsa
>
>
> "Jezebel" wrote:
>
>> Documents.Add Template:="C:\....\MyTemplate.dot"
>>
>>
>>
>> "Santiago Torras" <SantiagoTorras@discussions.microsoft.com> wrote in
>> message news:399A658D-F6B5-4481-87A9-94684E2D0F10@microsoft.com...
>>> 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....
>>> --
>>> thanks
>>
>>
>>

--
Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID