How to Move Excel Data to a Word Document

[VBAtechie]

The goal: Take data from Excel and plug it into specific spots in Word.

The start: Excel has columns of data. Each column is one series of data--one 'set' of data. For each set of data, I need to:
1. Open a particular Word file (It's always the same file--the blank form)
2. Sequentially plug in the data elements, cell by cell, into specific places in the Word document.
3. Save the Word document under a new filename,
4. Repeat until I run out of columns of data!

I can do everything listed except point 2. There I'm stumped, stonkered, and stopped.

Any brilliant solutions?

[Siddharth Rout]

Any brilliant solutions?

Yes... Search the forums
http://www.vbforums.com/showpost.php...53&postcount=2

http://www.vbforums.com/announcement.php?f=37&a=34

[VBAtechie]

Ah. "Look harder at the thing you already searched."

Thanks! I appreciate your insight!