Thread: File dosn't always close?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default File dosn't always close?
Hi Karl

Application.Close
This will not close a workbook

If you use this for example the workbook will be closed without saving

ThisWorkbook.Close SaveChanges:=False
If you want to save change it to True



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Karl Treier" wrote in message ...
Using

Application.Close
Application.Quit

the file appears to still be open sometimes

any ideas?




Reply With QuoteReply With Quote