Results 1 to 2 of 2

Thread: VBA Word Table to Excel Help

  1. #1
    Neophyte buhnee's Avatar
    Join Date
    Jan 2022
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016 MSO (V 2112)

    VBA Word Table to Excel Help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    I'm trying to make an adaptation to the code on this forum here to work to my specific case.
    https://www.excelguru.ca/forums/show...-Word-to-Excel

    In post 4 Macropod's VBA script uses a folder as the source and goes through multiple word docs to pull data into one workbook.
    However I only need a limited amount of data from the word document and I would like it to be added to a single worksheet.
    I'd Like to have a header and then have the macro put the data into the rows beneath each header.
    A new row for each word document it extracts from

    Date Time Location Tester FIR# Component Name Subcomponent Part# S/N Fault Description Class Dmg
    Document 1 >> >> >> >> >>
    Document 2 >> >> >> >> >>


    I have attached a copy of the form I need data from.

    Clear Form.docx

    Unfortunately, some of the info is sensitive to our company so I had to remove two of the content control lists.
    I need all of the information that is in red text.

    I hope this is enough information.
    Thanks in advance to anyone willing to help.

    V/r,
    -Buhnee

  2. #2
    Neophyte buhnee's Avatar
    Join Date
    Jan 2022
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016 MSO (V 2112)
    bump for support

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •