I've written a routine that loops through .txt files in a directory and reads one line at a time from the files into a row in excel. This code was functional and working, but now for no clear reason it gives me the error message, Run time error '53', File Not Found when trying to open any of the txt files.
The code has not changed, the path and files have not changed. Doesn't seem to matter what I do, whatever file I try to open I always get that message.
Could something have changed in the operating system? (I'm running Win7pro.) Any help appreciated.
Bookmarks