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

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

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

Dave,
I see what you mean. If the OP is opening the output file in a different
environment that does not expect the normal end of line combination, then
problems will arise.
As you say, depends what the aim is .

NickHK

"Dave Peterson" wrote in message
...
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