PDA

View Full Version : How to link Word and Excel fields in order to automate update of field values



LILO
09-06-2018, 05:08 AM
Good day, is it possible to "link" fields in Word and Excel in order to automatically update the value when maintained in either of these documents? See attached a Word document that is used as a take on sheet for new employees, as well as an excel document that is used as a employee master list. The idea is to update the employee master list for new employees and then insert the record into the Excel document automatically. Also when updating a value on either the take on sheet or the employee master list, it should automatically update the other.

macropod
09-06-2018, 04:14 PM
It is usually better to have Excel extract data from Word than to have Word push it to Excel. The extraction process gives you greater control over the quality of the data and ensures you won't run into access problems because someone already has the workbook open (which is a potential problem if you try to push the data from Word to Excel). There are numerous posts here for the extraction approach. See, for example:
http://www.vbaexpress.com/forum/showthread.php?40406-Extracting-Word-form-Data-and-exporting-to-Excel-spreadsheet&p=257696&viewfull=1#post257696