View Single Post
 
Old 09-28-2013, 07:22 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote