Populate Word Document from Excel

Hello,

I have an Excel sheet that contains data per row. At the end of each row, I want to put a button (or a hyperlink to a file) that will put the data from that row into a new Word document, something like a printer-friendly document.

Please find enclosed the Excel file and the DOC format that I need.

A single button would suffice though you can go to all that trouble if you like. There are 2 approaches, (1) Mail Merge and (2) Write to foreground in a new doc. (2) is probably the easiest for such a simple doc.

Record a macro and then insert the parts for the data. When you add the dummy data in the recording, type F1 for Field1's data, F2 for Field2 and so on. The user would select any cell from a row and run the macro. F1 and F2 values are found by:

Please Login or Register  to view this content.

Of course other methods like ranges for the field values could be used as well.

If you need more help, post back.

To take it a step further, why not create your "printer document" as a Word template (see attached: carpage.dot) with form fields. Then using the values obtained (As above) copy the values into the fields using the field bookmarks.

I'm not 100% sure on how to do this myself (I can get as far as creating the Word.Application, but get stuck) but I'm sure somebody here would know how.

-Bob

Originally Posted by beeawwb

To take it a step further, why not create your "printer document" as a Word template (see attached: carpage.dot) with form fields. Then using the values obtained (As above) copy the values into the fields using the field bookmarks.

-Bob

Yes, this is what I want. But I am not good in VB codes etc.,

Here is the method that I detailed. If you don't know MSWord syntax, just record a macro in it like you would in Excel. The only key that you need is how to reference the object.

Right click your sheet's tab, Insert Code, and put this code into the worksheet object. Then, just click a cell in Column I to generate the doc.

If you need to change column I without triggering the macro, change the name of the Sub and then change it back when ready to activate the SelectionChange event. This will let you put simulated Hypertext into the cells.

You only need to add the reference if you use the early binding method. Uncomment those 2 lines and comment the 2 late binding lines in that case.

Please Login or Register  to view this content.

Why is it not recommended to use an existing instance of microsoft word?

Since wa is set to nothing at the end, word application closes. What if you had not saved other docs that were open?