+ Reply to Thread
Results 1 to 2 of 2

Parse data from a word form to excel

  1. #1
    Registered User
    Join Date
    05-17-2020
    Location
    Cranfield
    MS-Off Ver
    365
    Posts
    1

    Parse data from a word form to excel

    Dear Forum
    I have a question bank for my students stored in an excel sheet.
    To correct spelling and grammar I export them to a word file using a form and the mail merge feature.
    The form structure has no vertical fields.
    question form.jpg
    This merging feature converts all the excel entries to word pages using a mapping process. Finally the excel records are extracted and each row record is converted to a word page. (26 excel records 26 word pages)
    Issue:
    The need is to reverse the process and import the corrected questions back to my excel sheet.
    Action
    I found a vba macro which parses the data for a form with vertical sturture but can't use it in this case.
    Do you think that it is feasible to parse the data from this mixed type form?
    Attached Images Attached Images

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Parse data from a word form to excel

    Cross-posted at: https://stackoverflow.com/questions/...-form-to-excel
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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. Import form data from word to excel
    By onsight in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-26-2019, 10:55 PM
  2. Exporting Word Form Data to Excel
    By Lau_B in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2018, 11:50 AM
  3. Exporting form data from MS Word to Excel
    By classiguy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-11-2017, 04:22 PM
  4. Want to move Excel data to a Word Form
    By brandomcg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-22-2013, 07:01 AM
  5. MS Word form data to Excel 2010
    By thereallukeg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-13-2012, 02:13 PM
  6. Copy data from Excel into Word form
    By alin_m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2012, 11:01 AM
  7. How to extract data from Word Form into Excel
    By arunjoshi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2006, 11:10 AM

Tags for this Thread

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