Possible, yes. Advisable, no.
Having Word work this way means that every time a survey document gets opened/updated, that Word session has to start Excel and, when data are added/edited, update the workbook. For however long that takes, no-one else can use the workbook. So, if someone opens a survey and doesn't close it, everyone else will be locked out. Plus it also means every survey participant needs to be able to access & update your workbook, in which case, you may as well just create a userform in the workbook and let them complete the survey there. Furthermore, by giving each user access to the workbook, either through a userform or a Word document, you create for yourself all sorts of issues related to tracking whether a previously-completed survey is being re-opened & edited and, if so, how to identify the data row to update, rather than adding a new row.
For the above reasons, it's advisable to collate the survey files into a single folder and, once you're done gathering the data, run a macro from Excel that goes through all the files and extracts the data.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|