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

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