Why can't I write out an Excel file?

G

greaseman

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

My problem: The code works beautifully on the first two sets of data i
finds, but when it encounters a third set of data, although the progra
reads through the data, it does not create a resultant third Exce
file. I've stepped through the code and confirmed that data is bein
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 i
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!!!
 
D

Dave Peterson

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.
 
G

greaseman

Dave,

Thanks for your reply...... the program is not waiting on a "do
you want to overwrite this file" message, and also strFileName i
picked from a file selection form.....

I have no idea what is happening..... no error messages sho, an
tracing through code indicates that data is being "grabbed," it's jus
not coming out to the Excel file.

If you have any more suggestions, please toss them at me......I'm goin
crazy
 
D

Dave Peterson

Just what I mentioned before--make that instance visible to see if you can see
anything strange happening.

Good luck.
 
Top