View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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/