Consulting

Results 1 to 2 of 2

Thread: How to link Word and Excel fields in order to automate update of field values

  1. #1
    VBAX Newbie
    Joined
    Sep 2018
    Posts
    1
    Location

    Question How to link Word and Excel fields in order to automate update of field values

    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.
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    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/show...l=1#post257696
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •