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 ?

Close Files Fast
 

Hello Ch,

Shuting down an application is not like turning a light on and off
There many factors that effect how long it takes to quit. Rushing th
process can lead to file corruption, data lose, or even crashing th
system. You just have to be patient.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=49642