how to get rid of "^M" in the output file
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 |
how to get rid of "^M" in the output file
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 |
how to get rid of "^M" in the output file
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 |
how to get rid of "^M" in the output file
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 |
All times are GMT +1. The time now is 12:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com