Recently i have seen the macro you have written for import text from word to excel. Based on your macro, i have copied more than 100 word docs in to sample file and run the marco (demo file).
The macro is picking up only the first word sheet and rest not picked by macro.
I cant attach the files for your reference. Can you please help me in getting the details for all word docs.