Consulting

Results 1 to 2 of 2

Thread: Extract word text from tables into excel

  1. #1

    Lightbulb Extract word text from tables into excel

    Hi,
    I am struggling to find a solution that can help me in extracting data from various word documents, that contain tables into a meaningful summary in excel. I have looked over the various threads but have not come across one that I believe I can apply to my situation. VBA is fairly new to me so my apologies if I have missed a thread that I could use.

    I have attached two files to give an example. The word file shows the typical format of the word documents, but in some cases there are more tables in some of the word documents, but I don’t next to extract those tables, only the data from the ones in the example.

    The excel file shows ideally the file format that I am hoping I may be able to create in extracting the data so that I can then use this.

    I really appreciate any help or advice that anyone may have time to comment on. Thank you very much in advance. Simon

    Example_excel file.xlsxExample_Word Document.docx

  2. #2
    Although primarily aimed at extracting data from e-mail to Excel, the principles involved are similar to those described at https://www.gmayor.com/extract_data_from_email.htm. See the section on tables. If the documents are not all in the same format then there is no simple solution.

    If you are just setting up this process it would make sense to use content controls in the Word document https://www.gmayor.com/insert_content_control_addin.htm to collect the data and that would make data extraction somewhat simpler https://www.gmayor.com/ExtractDataFromForms.htm
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Posting Permissions

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