G
gordian
I'm new to Excel vba programming, so I'm not sure if I'm doing the
right thing.
In my macro, if I do:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim fileName As String
Dim colIndex As Integer
Dim rwIndex As Integer
fileName = "test.txt"
colIndex = 4
Open fileName For Output As #1
For rwIndex = 2 To 10
Print #1, Cells(rwIndex, colIndex).Value
Next rwIndex
close #1
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
What I got in the output file were lines that ended with "^M". How can
I remove these characters?
Thanks
right thing.
In my macro, if I do:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim fileName As String
Dim colIndex As Integer
Dim rwIndex As Integer
fileName = "test.txt"
colIndex = 4
Open fileName For Output As #1
For rwIndex = 2 To 10
Print #1, Cells(rwIndex, colIndex).Value
Next rwIndex
close #1
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
What I got in the output file were lines that ended with "^M". How can
I remove these characters?
Thanks