Line Broken Transfering data to Word

[mhferreira]

Hi, Im transfering data from excel to MS Word via code.

But i dont know how insert a line broken in a string.


Example:
X="asdf"
Y="zcxv"

wdApp.Selection.GoTo What:=wdGoToBookmark, Name:="A"
wdApp.Selection.TypeText Text:=X &\n& Y

i try use \n but don´t wor

 

[Tom Ogilvy]

Try

wdApp.Selection.TypeText Text:=X & vbNewLine & Y