14 Jul 12 6:06
Personally I stay out of Word VBA it is cumbersome. you mentioned Excel as a data source I would start your newbie app in there. let it control Word. And if you learn VBA I know it will make your data manipulation in Excel a lot more efficient.
With Excel you need to save your code in the personal.xla(x) [extension depends on version or Excel].
Why? because when you open Excel all your code will be there and waiting and not inside each individual sheet. So what? well if you create a button on the tool bar to run your new macro it will be looking for it in the .xla file and not in another sheet which you don't have open.
Oh yes always tell us what version you are using because the VBA changed in some regards.
But with any of the VBA you have to set it up first.
you have to turn on the "developer" tab and again; thank you Microsoft depending on which version you have its different. even from 2007 to 2010.
Keep in mind Excel can control Word or anything using VBA. I use both it and Access.
And... last but not least welcome to the new world of programming. your life will change forever when you can wip out er (better yet, grind and beat out) a "macro" that can do what used to take hours or even days of copying and pasting, will be 1000's time faster. the agony of making the macro will be "click your button and the screen flickers an bingo it's all done".
"IF" you want to do this, then you need to...
1. turn on the developer tab
2. get to know how to add macro buttons to your "quick access bar"
3. tell us which version of "Office" it is.
4. bring us a code snippet as a starting point