Hello,

I have an Excel document that I have put together in which I enter
variety of data and it generates Charts that are on the same sheet.

I would like to place a button on the Excel sheet and upon clicking it
grab a MS Word Template and fill in the merge fields with the data.
would then be able to save the Word Document as its own file. The Wor
document does not need to be dynamic. I will create a new Wor
document each time I change/update the Excel data by clicking on th
button.

What is the best way to accomplish this? Button and Macros? Ho
should I create this Word Template?

If I could get some direction I am sure I could figure it out...thi
has to be possible...

thx in advance..
Mik

--
Message posted from http://www.ExcelForum.com