I bet that Gordian means that ^M is the carriage return character
(vbcr=chr(13)).

It's for end of line (along with vblf=(chr(10)) in DOS files.

But I'm not sure what the OP really wants.

A one line text file?

Print #1, Cells(rwIndex, colIndex).Value;
or
Print #1, Cells(rwIndex, colIndex).Value & " ";

or what???

To the OP:

Maybe it's just your text editor that's giving you the wrong impression. Try
opening the text file in Notepad. Does it look ok?

NickHK wrote:

Nothing in your code to indicate these "^M" chars were added, so I can only
assume they are in the cell values.
Check the source data.

Also, check the help for "FreeFile".

NickHK

"gordian" wrote in message
ups.com...
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


--

Dave Peterson