VBA QUESTION
 

I have a problem with a program that I created in VBA,
this program after doing all calculations it saves the
results on sheets within the same workbook, but it
converts this sheets in to .TXT files on a different
directory. Whwn it's done Excel remembers the last of this
files, is there a way to make the program save as the
original file wish was in (.XLS)
thank you

VBA QUESTION
 

Just before creating the txt files, save the workbook. Creating the
textfiles does a saveas, so the original workbook still exists. You can
have your code reopen it at the end.

--
regards,
Tom Ogilvy

"luar" wrote in message
...
I have a problem with a program that I created in VBA,
this program after doing all calculations it saves the
results on sheets within the same workbook, but it
converts this sheets in to .TXT files on a different
directory. Whwn it's done Excel remembers the last of this
files, is there a way to make the program save as the
original file wish was in (.XLS)
thank you