All
I am trying to change the "delimiters" in my csv file, so I can open it as an excel file.
I know the delimiter to separeate the columns is ';'. But what is the delimiter for a new line?
Thanks
All
I am trying to change the "delimiters" in my csv file, so I can open it as an excel file.
I know the delimiter to separeate the columns is ';'. But what is the delimiter for a new line?
Thanks
For windows machines:
vbCrLf
orChr(13) & Chr(10)
Carriage Return then Line Feed
If you are going to be using this code on multiple platforms, then
vbNewLine
will be whatever is needed for the platform (windows/unix/mac/whatever)