VB Macro to import Word content into an Excel Spreadsheet

[rafikarp]

Hi,

I am wondering if it is possible to program a VB macro that would open up a folder in a directory and open a Word file in that folder, copy the text and paste it back into an excel file, then close the Word document and open the next Word document, copy the text and paste the text in the next row etc.

Basically, I have a few hundred Word files that need to be copied and appended into an Excel spreadsheet.

The text in the word files is all in the same format (in a table).

If you have a good example of something like this it would be much appreciated. I can probably tweak the macro as required.

Thanks!

 

[venkat1926]

I suggest following
open an excel sheet.
create a macro
follow the steps you want for a 2 or 3 files and then see the macro .
the macro will give you idea how to edit the macro to extend it for 100 files.