Hi
I'm sure someone can point me in the right direction to solve my problem. Basically I wish to populate a word document with infromation from selected cells in an Excel 2007 worksheet. Using a drop down box on the spreadsheet I create (select) the fields of information I wish to "export". The code I have managed to find on various forums allows me to export to a specific Word 2007 document and this populates the relevant "bookmarks"... so far so good!
However I cannot for the life of me find a way to select which word document I wish to populate from a selection of 6 possible "templates".
Any help would be greatly appreciated

gastank