In post #5, are you talking about my code? I most always test code before posting solutions so I know that it "works".

Obviously, Dim line starts on line 2. When posting code to the forum, it often skips the first crlf.

When you say changed path, did it include the trailing backslash character? Did you also change the file extension if not .txt? Another reason for not working may be sheet protection?

Of course your base file name like ken.txt would need a matching sheet name of ken in one of sheets 2 to the last one.

Did you paste the code in a Module? Always Debug > Compile before doing a test run. That would catch the 2 lines on 1 line error I explained earlier. It is just a good practice anyway.

If still an issue, please post the code that you used. Or attach a simple obfuscated file.