Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2009, 09:45 PM
rynman rynman is offline
Novice
Word to Excel
 
Join Date: Mar 2009
Posts: 2
rynman is on a distinguished road
Default Word to Excel

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!

Reply With Quote
  #2  
Old 04-19-2009, 04:47 AM
zyzzyva57 zyzzyva57 is offline Word to Excel Windows 7 32bit Word to Excel Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

I am missing something, obviously...

Can't you just Copy and Paste?
Reply With Quote
  #3  
Old 04-19-2009, 04:50 AM
Matrix's Avatar
Matrix Matrix is offline Word to Excel Windows 10 Word to Excel Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
Matrix is on a distinguished road
Default

Due to the amount of the files, he probably wants to automate the process.
Reply With Quote
  #4  
Old 04-19-2009, 04:52 AM
rynman rynman is offline
Novice
Word to Excel
 
Join Date: Mar 2009
Posts: 2
rynman is on a distinguished road
Default

Yeah, I guess zyz missed where I said I have thousands to do.
Reply With Quote
  #5  
Old 04-19-2009, 05:39 AM
zyzzyva57 zyzzyva57 is offline Word to Excel Windows 7 32bit Word to Excel Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 04-19-2009, 06:50 AM
zyzzyva57 zyzzyva57 is offline Word to Excel Windows 7 32bit Word to Excel 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word to Excel Excel to Word retrospect1984 Excel 1 02-18-2009 06:41 AM
Connecting word and excel document jmarin Word 0 11-28-2008 02:55 AM
Linking from Excel to Word streng Word 4 10-28-2008 08:23 AM
Word to Excel hyperlinks and spaces gak Word 1 09-14-2008 08:38 AM
HELP! Merging Excel to Word peevenjo Mail Merge 0 07-06-2007 03:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft