+ Reply to Thread
Results 1 to 4 of 4

Extract Word header table data to excel (closed word document)

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2016
    Posts
    50

    Extract Word header table data to excel (closed word document)

    I have a table of file paths and file names for closed word documents. Here is an example:

    File Path File Name
    Q:\filepathexample\ docexample.doc

    In each of my closed documents there are 2 tables in the header. I need to extract the value of cell A1 in table 2 of the header, and paste it into my table in column C.

    I would prefer to do this without opening the word document, because I may be running this code for hundreds of entries in my table.

    Here's my code so far, I have defined the path and filename as strings, and the code it will loop through my table. I've had a little success with pulling data from tables in the body of the document, but I can't figure out how to access the tables in the header.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    02-06-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2016
    Posts
    50

    Re: Extract Word header table data to excel (closed word document)

    Here is what I have at this point. I still can't figure out how to access the table in the header.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Extract Word header table data to excel (closed word document)

    Can you attach the word document?

  4. #4
    Registered User
    Join Date
    02-06-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2016
    Posts
    50

    Re: Extract Word header table data to excel (closed word document)

    OK - I've got it solved, I finally found how to include the section and header as you set the object

    Like this:

    Please Login or Register  to view this content.
    So now I can pull the cell that I want from the word document, but when I try to run my code for a large list of file paths it only does about first 50, and then 10 or 15 scattered ones after that from my list.

    Is there any way to speed my code up? I THINK most of the processing is coming from opening and closing those word files.

    Please Login or Register  to view this content.

+ 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: 1
    Last Post: 03-25-2014, 11:23 AM
  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. [SOLVED] How to add header/footer to new word document through excel
    By RonNCmale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-30-2013, 03:07 AM
  4. Replies: 1
    Last Post: 07-05-2013, 02:30 PM
  5. Using EXCEL VBA to create word ,insert header in word, add textbox in header and fill pic
    By xiaorenwuhyl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2013, 05:32 AM
  6. Copy data from Excel and paste it in a table in word document
    By shekhar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2012, 05:28 AM
  7. Replies: 0
    Last Post: 06-15-2011, 02:22 PM
  8. Extract data from word document
    By hme in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2011, 04:37 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