+ Reply to Thread
Results 1 to 1 of 1

Macro to find text in Word and then exctract the full sentence to Excel

  1. #1
    Registered User
    Join Date
    03-28-2017
    Location
    New York, New York
    MS-Off Ver
    2010
    Posts
    20

    Macro to find text in Word and then exctract the full sentence to Excel

    Hi all,

    Is there a macro that can
    1. Select a Word docx file
    2. Search for multiple text strings
    3. Copy the full sentence that contains the strings found in step 2

    I have attached the Word document and expected Excel output. The text string criteria for Step 2 is in column C of the attached Excel, but I would like that embedded into the code itself.
    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. Replies: 15
    Last Post: 01-30-2018, 09:13 AM
  2. Find word in sentence
    By mastaliyev in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2015, 06:05 AM
  3. to find a word in a sentence in acell
    By erickmcburger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2014, 08:37 AM
  4. Replies: 7
    Last Post: 01-24-2014, 01:01 PM
  5. Find word in sentence
    By WCE_123 in forum Excel General
    Replies: 2
    Last Post: 09-21-2011, 06:59 AM
  6. How to find and replace a word in a sentence with VBA
    By Gunilla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-20-2010, 09:52 PM
  7. Find a specific sentence in a cell full of text
    By BClark86 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-28-2009, 01:16 PM

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