Hi all.
I've got a folder of Word documents all of which are in table format (they copy/paste to Excel perfectly, but obviously it's time consuming).
Is there any way to automatically import them into Excel, ideally each table into a separate tab, and to name the tabs the file name of the corresponding Word doc?
Thanks!
I've got a folder of Word documents all of which are in table format (they copy/paste to Excel perfectly, but obviously it's time consuming).
Is there any way to automatically import them into Excel, ideally each table into a separate tab, and to name the tabs the file name of the corresponding Word doc?
Thanks!