Run Time Error 1004 (VBA Code)

Hi Cheezee,

Your code worked for me, although it is NOT guaranteed to work, because Sub ProcessFiles() is fed a file name only. It tries to open the text file using the default path, and sometimes it may be successful.

See the following small changes made to Sub BatchProcess() in red:

Please Login or Register  to view this content.

Unrelated to your question, the above routine could be written with less code as follows:

Please Login or Register  to view this content.

I hope this helps.

Lewis