When you close each workbook, use something like...

application.ActiveWorkbook.Close savechanges:=False

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"mkilbour" wrote:

Using Excel 2007 on Windows XP: Monthly I select hundreds of Excel files from
Windows Explorer, right click and select Print. It would open an Excel file,
print it, close it and repeat for the next file. I could go home for the
evening, and the hard copies would be on my printer when I came in the next
morning. I am now getting a prompt asking if I want to save the file before
closing it. This means I have to be present and respond for every file it
opens. How can I disable this prompt?