Run Word Template from DOS

[JD Robbie]

I want to run and existing Word Template from DOS

Sequence of events in existing template
1) logs into database
2) read data and formats into tables
3) creates document index
4) Save As "word document"

What would the DOS command be to do this ?


Any help would be appreciated.

Thanks,
John

 

[Helmut Weber]

Hi John,
just one of so many ways:
c:\prg\office10\winword.exe "c:\templates\mytemplate.dot"
It is assumed, that there is an autoopen macro in
mytemplate.dot, which takes over control and performs
all the following actions.
To prevent all the automation from executing every time
mytemplate.dot is opened, you may add something like
Dim Result As Integer
Result = MsgBox("continue", vbYesNo)
If Result = vbNo Then Exit Sub
at the beginning of autoopen.

 

[John Robbie]

Thanks Helmut

John
Toronto, Canada