View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_75_] Mike[_75_] is offline
external usenet poster
 
Posts: 1
Default Merge into Word Template

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