Log in

View Full Version : [SOLVED:] Loop in Word, Replace String with Excel String



nautyraj1
11-26-2017, 04:31 AM
Hello all,
We have over a 200 list in Excel that contain Levels that we need to find (String)-Level in Word and replace with it or paste after Level.


The basic steps are:
1. Copy First Cell value in Excel (A1)
2. Find "Level" in word
3. Find text Level in Word and Paste after that word
4. Repeat step 1-3 with loop till 200 times.


Thanks

macropod
11-26-2017, 02:02 PM
See, for example: http://www.vbaexpress.com/forum/showthread.php?42897-Macro-for-replacing-EXCEL-data-into-WORD&p=272040&viewfull=1#post272040