Macro to copy data from multiple word doc to single new excel file

[Abhishekghorpade]

Hi,

I have 20 word document saved in a folder. I want to copy the data from all the files and paste it in a new single excel sheet.

Folder name - Downloads
Word document path - file:///C:\Users\E5554593\Downloads\
Word file name - Admin - Active Payroll Report, Admin - Active Payroll Report (1) and so on...

I am doing it manually which takes more than an hour to complete the task. Few Word Document has around 4k-5k rows

 

[Macropod]

This is a duplicate of: https://www.mrexcel.com/forum/gener...-multiple-word-doc-single-new-excel-file.html
Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.