| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why excel close all files when I just want to close one files | Excel Discussion (Misc queries) | |||
| All Files Close | Excel Discussion (Misc queries) | |||
| Fast Find possibly replacing .xls files | Excel Programming | |||
| Fast reading/writing of CSV files | Excel Programming | |||
| convert 400 word files to excel files fast? | Excel Programming | |||
Linear Mode
