vbNewLine

[Doogle]

This constant has me puzzled. The definition in the Object Browser is

Constant for NewLine; platform specific

which begs the question - What does 'platform' mean in this context?
(I'm not aware that VB code will run on Operating System 'platforms' other than the Windows family, except for, I guess, Windows emulators)

Even so, I can't see its value. If I create a file on Platform "X" where vbNewLine is defined as a Carriage Return and then try to read the file on Platform "Y" where vbNewLine is defined by a Carriage Return Line Feed pair I will have trouble (eg if I Split on vbNewLine I'll end up with one Array element) Porting a file from "Y" to "X" (and splitting on vbNewLine) would give extraneous LFs in the Array elements. That sorts out the 'specific' part of the definition.

Now, Microsoft wouldn't have gone to the bother if creating it if it wasn't useful(?)

Can anyone give me an example of the conditions where it's use would be more appropriate than the 'standard' CRLF pair? - I can't think of one. (perhaps I've just led a sheltered (programming) life )

[dilettante]

VB and VBA share common roots.

Mac editions of Office defined vbNewLine as CR or LF depending on the platform (Apple's old platform or the current BSD-derived platform). The point was to make the code portable, not the data files.

You could have a VBA macro in Excel that would process Windows data files on Windows and Mac data files on both flavors of Mac.


For whatever reason vbNewLine "runs faster" than vbCrLF in VB6 programs. It is also much better self-documentation to use vbNewLine when it represents a new line within text.

vbCrLf should basically never be used unless you want to force and imply that you are forcing CR/LF. A good example might be various Internet protocols, where by long-standing convention CR/LF is ALWAYS used as the "line delimiter" just as binary data ALWAYS uses big-endian order...

Except when people break the rules. The *nix johnnies have trashed the world in this regard. XML is fairly commonly shoveled across the 'Net using LF as new line. But you can't expect much from that lot anyway.

[dilettante]

There are other curiosities in VB6 too, some working but pointless and other not working. Example, try:

    MsgBox MacID("text")

Function MacID(Constant As String) As Long
Member of VBA.Conversion
Converts a four-character constant to a Macintosh file type or signature

This one seems entirely unfunctional:

Function MacScript(Script As String) As String
Member of VBA.Interaction
Executes an AppleScript script

[Doogle]

Dilletante: Thianks for that. I'd Rate your post but apparently I have to spread myself about a bit more !

[dilettante]

We do what we can. I have the same problem and I need to "spread around" more myself.

[kareninstructor]

Then there is Environment.NewLine in .NET

A string containing "\r\n" for non-Unix platforms, or a string containing "\n" for Unix platforms

[Nightwalker83]

which begs the question - What does 'platform' mean in this context?

Maybe it is the same as this? Although, this one is for Java but you should get the idea.