Maybe making the excel session visible before the save would help debug the
problem.

Could it be that strFileName is not correct or that you're waiting with a "do
you want to overwrite this file" prompt hidden?

xls.displayalerts = false
'your save line
xls.displayalerts = true

would be one way to avoid this prompt.

greaseman wrote:

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

--

Dave Peterson