I have about 4000 doc and docx files which contain a table. I've managed to import these into one excel sheet using the following script:
The only issue is that outside the table of the docs is a date. Because this isn't in the table, it doesn't pick it up and I have a huge list of data with no dates. How can I get it to import ALL the data or at least, the date into the excel sheet also. Without dates the data I have could be in any order and useless to me.
The document includes a top table, this contains information like revision number, page number, company name and date the form was made. All of which is not what I require. Beneath that is a line of text, the date and beneath that is the table which I want. The filenames also contain the date if that helps.
Bookmarks