LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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 ?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why excel close all files when I just want to close one files hon123456 Excel Discussion (Misc queries) 2 December 8th 10 12:12 PM
All Files Close S1L1Y1 Excel Discussion (Misc queries) 3 May 30th 08 04:35 PM
Fast Find possibly replacing .xls files Raul Excel Programming 0 March 15th 05 07:51 PM
Fast reading/writing of CSV files Chris Jakeman Excel Programming 2 August 6th 04 10:29 AM
convert 400 word files to excel files fast? CPower[_13_] Excel Programming 1 June 21st 04 10:29 AM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"