How to create word template with data from excel

**gerimo** · 02-19-2015, 02:03 AM

Here is situation:
I have excel table with list of staff (ID, workplace, e-mail, etc.). My idea is, when every employee open word template, he insert his ID and then word automatically filled header of template according to excel table.

Actually i have no idea how to make it. Is it possible suborn me to start?

Thank you.

**macropod** · 02-19-2015, 07:06 AM

You could do that with a macro like the following, stored in the document template's 'ThisDocument' code module:

Please Login or Register  to view this content.

The code assumes your IDs are in column A of the Excel workbook and you want to retrieve the corresponding data from columns B to D as well. You can adjust the column references as needed, including adding/deleting columns. The code assumes your document has a dropdown content control (see under Developer>Controls) with the title 'ID' (see under Developer>Controls > (select your content control) >Properties).

With the above code, you'll need to provide
• your own workbook path & name for:
StrWkBkNm = "C:\Users\" & Environ("Username") & "\Documents\Workbook Name.xls"
• your own worksheet name for:
StrWkSht = "Sheet1"
• your own bookmark names for:
Bookmark1 through Bookmark4

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm