Thread: [Solved] Linking to word to excel
View Single Post
 
Old 04-13-2014, 09:22 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote