Line Broken Transfering data to Word
 

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

--
Message posted from http://www.ExcelForum.com

Line Broken Transfering data to Word
 

Try

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

--
Regards,
Tom Ogilvy


"mhferreira " wrote in message
...
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 work


---
Message posted from http://www.ExcelForum.com/