convert 400 word files to excel files fast?

[CPower]

Hi Guys,

I have been sentenced with the task of converting 400 word documents
into 400 excel spreadsheets by today. either i find a way of doing thi
myself or the documents will be sent around the office for people to d
them manually. Is there any way of doing this through macros?

I was thinking of having a loop that once the macro is started, that
pop up asks for the location of the word file and when open is clicke
a new book opens and copys the data from the word file to the exce
file, then saves the excel file as e.g. data1.xls, thens closes th
excel file. Then the macro would loop and a pop up for the location o
the word doc would pop up again and this time save the file a
data2.xls and so on??

Could someone please help me on this one??

Thanks in advance
Cathal

 

[Bob Kilmer]

Well, perhaps this is moot now since you have either succeeded in automating
this or the files are being passed around the office by now. If not moot,
then sure, you have the right idea. Code could be written to do this, but it
may take longer than a day.

There are so many questions. If the most trivial copy and paste is
satisfactory and you can put all of the Word docs into one folder (or make a
list of the full path and file name of each -- I wouldn't want to browse to
400 Word docs if I didn't have to.) then *I* could code this in a day, but
could you?

 

[CPower]

You have a good point point i dont think i would be able to code this i
a day, and the customer got delayed in sending us over the files so
think i have a day or two to think more on the subject. If the codin
would take you a day to do, i think i might consisder doing thi
manually