1. Staring with info from an excel userform, what's best for taking text information from excel cells, manipulating it a little, and putting it into a Word document? word template or use commands in vbe or something else. Or should I put info from userform directly into the word doc? (I'm building an expert sytem to produce a multipage document based on a user's input).

2. Best means for getting alpha version into the hands of testers? Maybe a site that holds the excel spreadsheet and word document?


All my fortran experience from 100 years ago is not much help in the modern world. Who knew?

There isn't one best solution, it really depends on several things.
1. How is the Excel data created/updated?
2. Is the data going in to Word tabular or individual fields?
3. Are data fields appearing in Word in multiple locations? (Same info in multiple places)
4. What value is added by doing data entry in Excel rather than starting in Word?
5. Are individual documents produced or are you outputting a series of documents at the same time?

Solution options involving initial data entry in Excel could be:
- Mail merge
- Export to custom XML file which then gets embedded in Word which contains mapped content controls
- Macro to populate fields/bookmarks or Content Controls

I note that you asked if you should put the info directly in to Word so you are already thinking about Q4 above. If Excel adds no value then perhaps a Word only solution would be simplest and easiest to implement. I would be most likely to recommend a Word only solution unless you are producing multiple concurrent docs

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia