Calling multiple templates or same teplate multiple times in excel vba

Calling multiple templates or same teplate multiple times in excel vba

Post by Deb » Thu, 05 Oct 2006 23:07:53


Is it possible to open a new word document from excel vba and call same
word template multiple times using "Documents.Add Template". or call
different templates and append it to the newly opened word document.
Actaly i need to create a word document from excel using vba. The word
document uses many repeating lines of text and tables. I want to put
them in a template. But under certain conditions certains lines are to
b ommitted from the template.

for example

open main word doc

when condition A = true
add template 1

if conditon 1 then
delete bookmark1
else
delete bookmark2

when condition B true

add template 1

If condition 1 then
delete bookmark 3
if condition2 then
add text


could anybody help please. this is needed bit urgently.
many thanks
deb