Insert new line in string


#1

Hello guys,
Is it possible to insert a new line character in a string?
I found online something like “vbclrf” but that doesn’t work.

I want to concatenate multiple entries from a DataTable, send them to Clipboard and then send them to SAP via the “Copy from Clipboard” option.

Thanks in advance


Paragraph separator
#2

Did you check this?


#3

Hello,

Either Vbnewline or Environnement.newline should achieve what you want to do.

ex: str = Row1 & vbNewLine & Row2

Cheers


#4

Indeed, vbnewline did the job, thank you for that.

In case anyone else stumbles upon this thread, another solution that I found for SAP is writing Vertical Line (Ascii 13) and then BackSpace (Ascii 10). Don’t know the logic behind it, but it seemed to work