Import tables from all Word documents within a folder into excel

The code below imports a table from a selected MS Word file into excel and works perfectly, but I would like it to repeat the process for all files within a selected folder, recording the file name and placing the extracted information from each document below that of the previous one, or in a new worksheet - whichever is easiest. Any help would be much appreciated

Please Login or Register  to view this content.