I've got a VB project that cycles through a txt file and extracts data from that txt file into Excel files. The project creates Excel files based on what it finds in the txt file.

My problem: The code works beautifully on the first two sets of data it finds, but when it encounters a third set of data, although the program reads through the data, it does not create a resultant third Excel file. I've stepped through the code and confirmed that data is being encountered.

Is there a limit on the number of Excel workbooks that can be created? Here is the code snippet I have at the end of my project, after data is processed:

xls.activeworkbook.saveas Filename:=strFilename & ".xls", ReadOnlyRecommended:=False, CreateBackup:=False

xls.activeworkbook.Close

xls.workbooks.Add
xls.Visible = True


Any help is most welcome! This is driving me crazy!!!!