You can do this, sceneitguitar. But you're going to have to write a VBA program to do it, and you're going to have to start by collecting the data from the Word documents using the Word Application object. Oh, the code can reside in Excel, if you want to do it that way; but it's nevertheless going to have to talk to the Word object. That means you'll have to learn how to automate in Word as well as in Excel.
I've done both, and although I know Excel objects a lot better than the Word object, it's not too hard; it's just very, very different.
Are the folks on the Word forum any use for this? Because unless you're a self-starter, you're going to have to ask them a lot of questions about how VBA/Word works.
|