VBA QUESTION

[luar]

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

 

[Tom Ogilvy]

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.