Excel Spread Sheet to form word document

Hi,

I'm not sure weather this is the correct place to post this question, as it just as much involves word as it does excel.

I currently create a couple of new word documents every week where 95% of each document are the same, 4 % are still standard paragraphs but dependent on the project (i.e. from a choise of pre set paragraphs) and the last 1% is dependenton on each document.

Is there any way to create a standard excel template where various document specific questions are answered which will then decide on the relevent paragraphs. And questions can be answers to determin the other 1% of information that then automatically updates a standard word template.

This will greatley spead up the process and standardise the documentation.

Cheers for the help,

Screamer

Hi,
You can use the File system object to read a text file, line by line.
Save your template in a text file. You can embed markers such as Part1, Part 2, Part 3 etc. which you will delete before output to word. Obtain dynamic content from your user using a userform. Insert dynamic input where you put your markers and then output to word. Hope this helps. - Steve