Modules & VBA :: Unwrap Text For Import And Reformat As Table

Getting close, but missing a step or two. Have a series of text files that need to be cleaned up and reformatted. The issue is two fold. Need to remove hard return wrapping so that each line is complete and then format to a table structure. I built code that imports fine if no wrapping. I tried this link and seemed to work, except in my implementation it is putting in delimiters, so that if a row of data has a comma, it treats that as a separate field rather than a single field. I thought that fixed width would mean that it ignores potential delimiter characters.

[URL]

The other problem is with the logic so that sometimes in is concatenating a new line to the old line. There may be exceptions due to typos and older files that used a tab rather than space, but seems in general like the indication of a wrap termination is that a new record will begin with either a number period and space or a letter (a, b, c, d only) a period and a space. The next part of building the table is tricky because the question needs to be repeated for each response as shown below in phase 2.

Example from plain text file (xxx.txt):
1. This is line one sentence
a. response a
b. response b
c. response c
d. response d
2. This is line two sentence
and it wraps
a. response a
b. response b
c. response c is
also wrapping
d. response d
----------------------------------
Phase 1 result should be:
-----------------------------------
1. This is line one sentence
a. response a
b. response b
c. response c
d. response d
2. This is line two sentence and it wraps
a. response a
b. response b
c. response c is also wrapping
d. response d
----------------------------------
Phase 2 result should be an access table with several cols:
-----------------------------------

Code:
QNO Question Response Answer
1 This is line one sentence a response a
1 This is line one sentence b response b
1 This is line one sentence c response c
1 This is line one sentence d response d
2 This is line two sentence and it wraps a response a
2 This is line two sentence and it wraps b response b
2 This is line two sentence and it wraps c response c is also wrapping
2 This is line two sentence and it wraps d response d

Here is the code that I'm trying to use for unwrapping.

Code:
Private Sub btnUnwrapText_Click()
'Create a new text file that has removed the wrapped text
'assumes that wrapping only occurs on second line. If
'wrapping exceeds two lines, code won't work. Haven't had

[Code].....