+ Reply to Thread
Results 1 to 3 of 3

VBA to Extract Specific table data from multiple words to one excel worksheet

  1. #1
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    130

    Post VBA to Extract Specific table data from multiple words to one excel worksheet

    Hi Team,

    I have the below request: Extract specified tables from multiple words to one excel worksheet

    1. Open multiple word files one after other
    2. Copy tables from the word files with a pre defined column headers (not all tables). There are several such tables in a single word file itself that needs to be copied.
    3. Create a "Master" Worksheet and paste the tables. Include the file name as a starting column for recognizing the data from which file is copied.
    4. Close the opened word files without saving and move to the next word file in the folder.

    Thank you so much
    Shan
    Last edited by santanuKD; 04-24-2024 at 07:25 AM.
    Shan

  2. #2
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: VBA to Extract Specific table data from multiple words to one excel worksheet

    Any response on this request please?

  3. #3
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: VBA to Extract Specific table data from multiple words to one excel worksheet

    Here is my working vba. Additionally I want the Heading & Sub Heading details to be added next to the table where the table was present in the word file. Attaching the word file for reference and trial. /Option Explicit

    Please Login or Register  to view this content.
    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. Extract word tables (multiple files) into excel using VBA
    By purple_milk in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 04-25-2024, 01:03 PM
  2. [SOLVED] Extract multiple words from a cell in excel
    By rituraj851 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 10-17-2023, 05:36 AM
  3. [SOLVED] Search and extract multiple words from an excel cell
    By fsm458 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2022, 06:53 AM
  4. [SOLVED] Extract & Categorize from Master Tables Into Multiple Tables
    By mycon73 in forum Excel General
    Replies: 8
    Last Post: 05-14-2018, 01:13 PM
  5. Extract word tables (multiple files) into one excel sheet using VBA
    By hguehring in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2016, 08:54 AM
  6. How to search and extract specific words from an Excel worksheet ?
    By newbr33d in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-25-2008, 06:45 PM
  7. extract key words/data from multiple files -dump in new worksheet
    By MikeR-Oz in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 03-20-2006, 04:15 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