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!!!!


--
greaseman
------------------------------------------------------------------------
greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808
View this thread: http://www.excelforum.com/showthread...hreadid=535496