Word to Excel

[rynman]

Hi guys



I have thousands of Word documents. Basically what I want, is something that can copy all of the data contained in each document, into it's own Excel cell vertically. So in other words, each Word document has it's own cell in Excel with everything contained in it.

Thanks for any help you can lend!

[zyzzyva57]

I am missing something, obviously...

Can't you just Copy and Paste?

[Matrix]

Due to the amount of the files, he probably wants to automate the process.

[rynman]

Yeah, I guess zyz missed where I said I have thousands to do.

[zyzzyva57]

A big Ouch on this one!

Mail Merge, maybe?

I suppose a top line VBA programmer could pull this off

You might try a M$ forum on VBA

What stumps me is automatically working down a list of docs one after the other to move into Excel cells one after another

[zyzzyva57]

I created a table in Word with one row of one cell, say a 100

At the first cell, I started a micro

Next I did a Micro to open a doc I wanted, select all, copy, close the doc to go back to my word doc with a table

I pasted the doc's contents into the cell

I moved the cursor down to the next cell

Stopped my micro

When done, I coped and pasted into Excel

If your docs are in order, you should be able to get one doc after another to do this

The problem you will probably have is auto'ing moving down one file after another to do this

Here is one solution...