Import multiple word docs into excel

All the data in the word docs are uniform, 3 small lines of text all separated by a row.

ex:
"patient name"

"patient d.o.b."

"patient gender"


*edit*
Or even without the document title, just the 3 lines of data within the .docx will do.
Also I am using Excel 2013

So I figured out how to convert all my .docx files to .txt files using this code in word:

Please Login or Register  to view this content.

Which is only half of my issue... I need to figure out how to properly format these text files into excel correctly. I have seen many different methods of how to import all these but none have the data formatted specifically to my needs... This is where I truly need help. I have not double posted this question ANYWHERE ELSE!

What I have:
About a thousand .txt files with 3 lines of data separated by a blank row that looks like this:
"name"

"D.O.B."

"gender"


What I need:
Each .txt file to be imported to it's own row (one row per file) and then each line of text separated by column.
So one row and three columns per text file.
The name of the files don't matter only the text data within and they are all in the same file location

So I FIIIIIINALLY figured out a simple program that will read all my TXT files and import to excel to almost the format that I need... almost...

Please Login or Register  to view this content.

Still not in the right format. And still no reply...
Does anyone still read these forums or is it just a long forgotten archive of old inquiries?

Im hoping that the reason no one has replied is because I have not been thorough enough of explaining what I need (hmm).
So in hopes to that, I am attaching a workbook.
Sheet 1 has what I get with the code above.
Sheet 2 has the format that I need the data to be organized as when I import all my text files.

Please guys, I have not asked anywhere else because that's your rule... I'm Hoping to get an answer soon but I cant wait forever. Time is about up and I will have to start posting my question somewhere else if I cant get any help here.

I'm not sure how you are looping through the files, but this will ask you to find a file and will split the file the way you want and then ask for another file. I suspect that you're situation will use a different loop. It will work with .txt, .doc, .docx and .docm files, as well as others.
Note that Word must be closed when you start this.

Please Login or Register  to view this content.