To find word in Microsoft Word Table and copy Offsets to Excel Cells
Hello
Is it possible to use Excel VBA on a Word Document, and after finding a table in that Word Document to search within that table (in its cells) for a word and copy some cells (Offsets) from the same column, but lower rows (like the Excel Offset) to Excel? Or to find the cell and copy its offset from the next column to Excel? In short can VBA Excel look for a word in a cell within a Word Table and get the offsets near it (below in or from next column) to be copied to Excel?
Has anyone tried this? I know how to do it from Excel -> Excel but don't know how to do Word->Excel
If it's possible I would really be grateful if someone could give an example of how to find a cell in a word table and then copy the cell from next column or the cell from the row below.
For example if there is a Table in a Word Document like this
Fruits Quantity
Apples 5
Pears 2
Oranges 8
Is it possible to look using an Excel VBA into the Word Document Table for "Fruits" and if fruits is found to copy Apples to Excel on A1? Or, alternatively to search for Apples within the Table and to copy 5 on B1 in Excel
Many thanks
John