View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CH CH is offline
external usenet poster
 
Posts: 49
Default Close Files Fast

I have a macro that goes like this :

Application.FindFile
FirstBk = ActiveWorkbook.Name
..
..
..
Windows(FirstBk).Close SaveChanges:=False


This is working just fine except that it takes a while for the file named
FirstBk to close. Anyone has a faster way ?