Thanks for the effort, however, it still will not save the output.txt without prompting to save output.txt. Could this have something to do with the fact that the excel docs I am trying to run this on contain macros???