+ Reply to Thread
Results 1 to 5 of 5

Extract to Excel from Word Document with track change mode

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    16

    Extract to Excel from Word Document with track change mode

    Hi All,

    I have an requirement to extract the contents from the word document which is in table format to excel...
    The case is:
    Word document content in table format.. there were four columns A,B,C & D.
    column D contains the texts with track change mode on, that is the text inserted and deleted with strike mark.
    In excel, i have to copy the column C contents as it is, Column D contents without track change accept, column D contents with track change accept.

    Can you please provide any references to achieve this?

    Thanks in Advance,
    ShailShin

  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: Extract to Excel from Word Document with track change mode

    Is this just for one table in one Word document? If so, simply accept the changes, then do the copy to Excel. If you don't want to permanently accept the changes to the document, simply close it without saving.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    05-21-2014
    Posts
    16

    Re: Extract to Excel from Word Document with track change mode

    Hi,

    yes, this is only for one table. Will try with the mentioned options.

    Thanks,
    ShailShin

  4. #4
    Registered User
    Join Date
    05-21-2014
    Posts
    16

    Re: Extract to Excel from Word Document with track change mode

    Hi,

    I have tried with the below mentioned code from other references....
    This does the copy from word table data to excel without track changes on.
    However, i have requirement to copy only two columns C & D data from word table to excel where in excel the columns will be C D E here, D without track change E with track change accepted
    Please Login or Register  to view this content.
    Thanks,
    ShailShin

  5. #5
    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: Extract to Excel from Word Document with track change mode

    Cross-posted at: http://social.msdn.microsoft.com/For...?forum=worddev
    For cross-posting etiquette, please read FORUM RULE 8: http://www.excelforum.com/forum-rule...rum-rules.html

+ 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. Need a macro to extract track changes and comments from Word to Excel
    By serene11111 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2014, 06:35 PM
  2. How can I Extract data from Word document to populate Excel spreadsheet
    By NYC4LIFE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2014, 10:10 PM
  3. Replies: 1
    Last Post: 10-10-2013, 10:53 AM
  4. Replies: 1
    Last Post: 07-05-2013, 02:30 PM
  5. How to change a excel document into a word document?
    By wannaknow in forum Excel General
    Replies: 1
    Last Post: 07-27-2005, 05:05 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