Excel -> Word

E

Ekser

Hi,

In my Excel sheet, the user populates the rows with data. Once he'
finished, he can push on a button which will create a (printable) Wor
document with data from the row (+ some extra features).

How to do this? Is there any documentation available for this?

I guess this isn't that easy, but a hint would be helpfull.


Thanks
 
S

Steve Yandl

http://word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm

The above example shows how to check if Word is already open and take the
correct action to generate a new document. It does some things with Find
and Replace rather than what you want but it's a start. I find it best to
build a Word template containing bookmarks where you want the data from your
workbook cells to be placed but if you don't have a lot of text you need in
the document you can easily just create a new document from scratch each
time.

Steve
 
Top