Chipley,
I've only scratched the surface of your code. Delimited exports fascinate me. As I looked at your code, I noticed a wee point. Refer to the following code snippet from your routine ExportToTextFile:
[vba]For RowNdx = StartRow To EndRow
WholeLine = ""
For ColNdx = StartCol To EndCol
If Cells(RowNdx, ColNdx).Value = "" Then
CellValue = Chr(34) & Chr(34)
Else
CellValue = Cells(RowNdx, ColNdx).Text
End If
WholeLine = WholeLine & CellValue & Sep
Next ColNdx
WholeLine = Left(WholeLine, Len(WholeLine) - Len(Sep))
Print #FNum, WholeLine
Next RowNdx[/vba]
What do you do when 'Cells(RowNdx, ColNdx).Text' contains one or more embedded separator characters? Won't this throw off any subsequent import or manipulation that depends on the sep characters?
Just curious,