Macro MS Word 2010 to Excel 2010 with Track Changes

Posted on 2014-08-29
Last Modified: 2014-09-30
Dear expert,

Needing to take all paragraphs in word and paste them in cells going doing in excel inclusive of all track changes in word i.e. To read in the cell as it does in word doc.

Best regards,
Question by:easycapital
    LVL 25

    Expert Comment

    are there any other objects , tables etc in word? or it is just the text with track changes?

    Author Comment

    Just text. Thanks.
    LVL 6

    Accepted Solution

    Does this do what you need?

    Step 1: In Word, convert the text to a table (Insert, Table, Convert Text to Table, Separate Text at Paragraphs)
    Step 2: In Word, select table
    Step 3: In Excel, paste.  Then resize the column width/row height as required.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
    Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now