Hello,
I am working a spread sheet that I am using to compile
data and turning that data into charts etc....
I am attempting to put together a template Word Document
that I can merge this data/charts into...I want to put a
button on the Excel Spread sheet that I can click on and
it takes the current data from the Excel Spread Sheet and
merges it into the Word Template. If there are changes
on the Excel Sheet I would have to click on the button to
create a new Word Document.
I assume that I do this by using embedded objects. How
do I setup my Word Template? Do I just install a Form
Button and attach a Macro to it? Or do I have to have
some custom
VB programmed?? Are there any good
tutorials/examples that anyone is aware of?
Thanks in advance...
Mike