+ Reply to Thread
Results 1 to 2 of 2

Pulling information from word to Excel

  1. #1
    Registered User
    Join Date
    06-13-2016
    Location
    Maryland
    MS-Off Ver
    2010
    Posts
    25

    Pulling information from word to Excel

    Hi! I have a Word form that I created that employees need to fill out when something is wrong with a piece of equipment. It is meant to allow us to see what caused the issued and know how to correct it so we can look for patterns in the issues that occur and work to prevent them in the future. I also created a spreadsheet in Excel that has column headings that align to the form field in the Word document. I was wondering if there was a way for me to create a button on excel that would allow people to enter the name that they saved each Word doc under and it would pull the information from the form fields and into the respective spreadsheet columns. I have attached a copy of the Word doc and the excel sheet I have so far. I appreciate any help!
    Attached Files Attached Files
    Last edited by Maddie77; 06-24-2016 at 11:02 AM.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Pulling information from word to Excel

    These should help. If you need more help, post back.

    'FormFields
    ' http://www.mrexcel.com/forum/showthread.php?p=1639696
    ' http://www.mrexcel.com/forum/showthread.php?t=333200
    ' http://www.excelforum.com/excel-prog...from-word.html
    ' Content Controls
    ' http://www.vbaexpress.com/forum/showthread.php?t=39654

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 2010 Word form fields populated with 2010 Excel data
    By pballard66 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2014, 11:55 AM
  2. VBA to extract information from a form in Word 2010 into Excel 2010
    By alvinaloy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 03:42 AM
  3. Importing data from an Excel 2010 worksheet into a Word 2010 form.
    By Kuriakos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 02:49 PM
  4. Copying worksheets from excel to word in vba as images
    By papasideris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 11:32 AM
  5. Searching the particular numberfrom excel'2010 table and locate the number in Word'2010
    By jaffirahamed1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2012, 08:09 AM
  6. Placing chart Excel 2010 with absolute position into Word 2010
    By marek12886 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2011, 03:32 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1