+ Reply to Thread
Results 1 to 3 of 3

How to export data in MS Word to Excel

  1. #1
    Registered User
    Join Date
    07-07-2010
    Location
    Kuwait
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2013
    Posts
    2

    How to export data in MS Word to Excel

    Hi,

    I have hundreds of Word files contains data in a table formatted. Each file contains one data in one page.
    Now, I like to put those data in Word files into an Excel file.
    1 Word file it will be saved in 1 row in Excel.

    Attached files are the format in Word and in Excel.

    How can I achieve it?
    Attached Images Attached Images
    Regards,
    Emir

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,896

    Re: How to export data in MS Word to Excel

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    07-07-2010
    Location
    Kuwait
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2013
    Posts
    2

    Re: How to export data in MS Word to Excel

    Hi,
    Thank you for the respond.

    Word file that I've attached is the source data that I want to copy it into Excel file.

    I have created a macro to do that by copy the table in Word file - paste it in a sheet and press the button to copy all data in those table into another sheet.
    It worked fine.
    But, is there any other way to do that process by reading all the Word files from a specific folder?
    Attached Files Attached Files

+ 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. Export data from Excel to word
    By matt.howard in forum Excel General
    Replies: 1
    Last Post: 08-14-2017, 11:28 AM
  2. Export data from excel to ms word
    By ROHAN999 in forum Excel General
    Replies: 0
    Last Post: 09-19-2013, 12:44 PM
  3. Export excel data to a new word file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2012, 12:11 AM
  4. Export data from Excel to word
    By delboy2405 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2012, 05:36 AM
  5. Export excel data into word
    By Internoob2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2011, 02:59 PM
  6. Export Data from Excel to MS Word
    By Avinash Kumar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2009, 02:27 AM
  7. Can Excel Export Data to Word Format?
    By Reddiance in forum Excel General
    Replies: 2
    Last Post: 04-18-2005, 02:06 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