Change vbNewLine on Excel VBA (Office 2004 Mac OS X)

[Ismannen]

I would like to avoid using 0x0D as new line when I write a text file from
Excel VBA:
Open "Testfile.txt" For Output As #1
Print #1, "Hello"
Print #1, "World"
Close #1
Doing it in the above manner gives me annoying ^M instead of newline on Mac
(using
"less" for example). Is there a way of changing vbNewLine to something more
....
sensible ...

 

[Steve Rindsberg]

I would like to avoid using 0x0D as new line when I write a text file from
Excel VBA:
Open "Testfile.txt" For Output As #1
Print #1, "Hello"
Print #1, "World"
Close #1
Doing it in the above manner gives me annoying ^M instead of newline on Mac
(using
"less" for example). Is there a way of changing vbNewLine to something more
....
sensible ...

I don't think so. But you could cobble up the entire string ...

strTemp = "Hello" & vbCr
strTemp = strTemp & "World" & vbCr

then finally Print just strTemp to file.