I am using an Excel spreadsheet to open a Word template then save it a
a specified name after entering details from the spreadsheet into th
Word document. The trouble I am having is how to define where the dat
is entered. Currently I am using code such as the following...

appWD.Selection.MoveDown Unit:=wdLine, Count:=4
appWD.Selection.MoveLeft Unit:=wdCharacter, Count:=2
appWD.Selection.TypeText Text:=strReference

But there are a lot of cells to enter into the 6 page template and thi
gets confusing, not to mention the fact that one small change at th
begining of the template would mean having to redo the other cells. I
there a better way of doing this? How? Perhaps somehow inserting field
in Word that the excel sheet updates?

Please help :D:D:D:

--
ChrisMattoc
-----------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...fo&userid=3391
View this thread: http://www.excelforum.com/showthread.php?threadid=54055