Sorry to say but it works fine for me... As the error is 'File not Found' it is probably the way you are constructing the filename.
This code requires the directory to be added in cell C1. It uses a combination of directory and root filename in Col A to find a file ignoring the extension (I would assume you do not have files named xxx.txt and xxx.csv in the same directory).
It also pops a msgbox if either the directory or any file listed in Col A does not exist...
The choice of cell C1 is purely arbitrary - it can be anywhere, just change the code to suit.
Bookmarks