Hi,
I noticed that you have used the code: ActiveWorkbook.close.
Try using this instead:
Application.quit
This will totally close the workbook without prompting for a save, an
withoput saving any open workbooks. You might want to put in a warnin
about that in your MsgBox.
Cheer
--
Message posted from
http://www.ExcelForum.com