View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Phil Phil is offline
external usenet poster
 
Posts: 15
Default Activeworkbook.Saved

Otherwise use this code
Workbooks("yourfilename.xls").Close savechanges:=False