Bob,

Yes, that is exactly what I am looking to do. And I agree with you that it would be easier to include the macro in the excel file vs. the word as the function will happen immediately.

However, there are a few concerns for functionality - Do you have to have both the E.xlsm and C.docx file open for it to work? If I change the date into the E.xlsm without the C.docx document being open will it update this information when I do open the C.docx?

Finally, the bread and butter - what code is required to make it work?

Thanks for all the help, you are certainly a beast at Microsoft Office! Keep up the good work!

Best Regards,
Jerald