View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default How do I bypass the message to save when closing a file by macro?

The best approach would be this:
Dim File1 as Workbook
Set File1 = Workbooks("YourWorkbook.xls")
File1.Close False

Charles
sjmpcec @ anon. com wrote:
When closing a file via macro, I continue to get the message do I want to
save this file. Can someone help me bypass that message.