Far from an expert in this field, but I use a small Excel macro run trough a text file in order to correct some data.

In principle it is not more complicated than the string below :

Sub Tidy_up_my_file

Selection.Replace What:="BETWEEN PT", Replacement:="BETWEEN", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=True

ActiveWorkbook.Save

ActiveWorkbook.Close True

End Sub

However, by some reason the command ActiveWorkbook.Save adds the double quotation marks on some lines in the txt-file (as line 4, 5 and 6 below).


:20:NONREF
:25:025121215508036
:28C:BETWEEN 129/1
":60F:C090701DKK4732,19"
":62F:C090701DKK4732,19"
":64:C090701DKK4732,19"
-}{5:}



Anyone having a clue what to do here? The question is in other words - how to do to avoid getting these quotation marks when saving the file?

Thanks in advance for your support.

/Steve