Word to Excel

d0o0n7

Board Regular
Joined
Aug 12, 2008
Messages
53
I have 100 word .doc files, each file name is "Section A.doc" and each file is in different folders

I want to search file which named "Section A.doc", then open all 1 by 1 copy the entire data in new excel sheet in same workbook. Like sheet 1 to sheet 100 contains each word file data

I know how to open word file through vba but don’t know how to find and copy entire word file. Please help me in this


Thanks;)
 
Last edited:

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,102,344
Messages
5,486,310
Members
407,539
Latest member
ltwkuav

This Week's Hot Topics

Top