Thread: [Solved] Word to Excel
View Single Post
 
Old 04-19-2009, 06:50 AM
zyzzyva57 zyzzyva57 is offline Windows 7 32bit Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

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...



Reply With Quote