Hello.
First many thanks for the assistance of this group and Macropod who has helped me to get started via previous posts and to navigate and understand rules of the forum.
I have the basics of the code working, thanks again to Macropod's previous posts.
My issues with the original code is that
(1) it only brings in the first 4 items in the document.
(2) it doesn't check and extract data from multiple docs in the same folder
Once I have those resolved the basics are in place.
(3) In addition to bringing in the data from a Word doc to Excel (2013) I am looking to have the data populate specific columns in the excel spreadsheet according to the master Excel spreadsheet.
https://www.dropbox.com/sh/nf0og7evr...FIke6jaFa?dl=0
In that link I have provided:
-2 data entry forms with data (WORD)
-Master data entry form that shows all fields and the corresponding column in Excel where it should populate in table format (WORD)
-Spreadsheet sample used to create the master sheet and identify corresponding columns (EXCEL)
-code used that extracts the first 4 lines of only one doc in the folder (TXT)
Many thanks, your assistance is much appreciated.
I am using this forum as my ongoing discussion on the topic.
Please note I had also originally posted this discussion here:
Cross posting reference: https://social.technet.microsoft.com...013?forum=word
Bookmarks