Extracting questions/answers from word doc to excel

[kmc546]

Hi all!

I am working on automating and simplifying some processes on my business team, and could use some help with this macro.

Context: we do text analysis on interview questions. There are about give or take 20 questions per interview, depending on the project. They are recorded, sent to a transcription service, and come back to us in word documents. We need to get the contents of the transcript into columns in the excel sheet, with the question being the column header.

For inserting the questions as the header I have a simple fix: put the questions into a table and have a macro read the table.

The problem is that I need to come up with a macro to read the answers in these transcripts based on formatting, rather than being in a table. We can have anywhere from 30-50 transcripts per project and multiple projects at at time, so it's not feasible to copy and paste.

Here is a photo for reference: the question will be bolded, and the answer will be below.
We need it to go into the excel as seen just below that.

Capture.PNG

Here is my current code as far as I have it:

Please Login or Register  to view this content.

Thanks in advance!

[zhouyiqing]

Assume each question has two answers and the word file saved at the same location of the excel file and named "Question.docx".

Please Login or Register  to view this content.