I have a pretty lengthy single module in an excel file which runs fine
when the input file consists of approximately 8,000 or less records.
However, if the input file has 9,000 records or so then the macro
fails at a point when it is trying to move the worksheet from the
input file (a .txt file which is read in as pipe-delimitted and then
parsed) to another excel file which takes the input file data and
performs additional parsing....etc. etc.

I have seen lots of discussion regarding 1004 error messages, but not
anything related to erros associated with what I am experiencing which
is definitely tied to the number of rows from the original text file.

Currently, I am just breaking the input file into 2 and running the
process twice. I'm hoping there is a better solution?

Any ideas?

Thanks in advance for your help.