OK, we create "Letters of Acceptance" using the same template multiple
times a day, I have designed an excel spreadsheet that has all the
fields necessary and a word document linked to this that is formatted
exactly how we need it. You fill in the details in the excel form, load
up the word document and voila! all the fields are there and correct.

Then the problems start, I need now to save this document as it is,
under a different file name. But so that when it loads up it doesn't
look for the linked information. It's no use just saying "never click
on the update linked information button" as the people using it will do
this regardless, and then the document will update to whatever is in the
excel spreadsheet. Any ideas? email me and I will gladly send you the
two documents! Thanks for your time, hope someone can help!


Even better would be having the excel spreadsheet generate the word
document by clicking a "generate" button then asking for a file name?!
Possible? Considering the format of the word document is fairly
intricate and important? Could excel update a template in word then
save it under a filename specified in the excel spreadsheet?

Please help me excel gurus!


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=536859