DataArray=Split (Input $(LOF (1), # 1), vbLf
DataArray=Split (Input $(LOF (1), # 1), vbCRLf
What's the difference?
Input $what is the difference between the input? Thank you for your
CodePudding user response:
VBCR is enter=CRH (13)VBLF is a newline=CRH (10)
VBCRLF is + newline=CRH (10) + CRH (13), still have a kind of writing in the vba: vbnewline
Basically see your data processing is wrap or press enter, or hybrid, generally in the TXT file is to use VBCRLF, not sure when these in turn have a try