| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Faster closing of large spreadsheet
I use a Trend.xls to compile several other spreadsheets into. I copy and
paste some data into the master, in this case Trends.xls. When I close "Impromptu DataDump rev3 2005 to present.xls", it takes up to 15 minutes. It does not have any "upon close" code. Is there a better (faster) method to use than the sample I have included below? Thanks Steve Workbooks.Open Filename:= _ (WhereDump & "Impromptu DataDump rev3 2005 to present.xls"): ReadOnly = True Worksheets("Sheet1").Range("A2:BW40000").Select Selection.Copy Workbooks("Trends.xls").Activate Worksheets("Product_Code").Range("A2").Select ActiveSheet.Paste Application.StatusBar = "Closing Data Dump........." Workbooks("Impromptu DataDump rev3 2005 to present.xls").Close SaveChanges:=False |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB to clear any filters when closing a spreadsheet | Excel Discussion (Misc queries) | |||
| Closing Excel spreadsheet | Excel Discussion (Misc queries) | |||
| Making a spreadsheet calculate faster | Excel Discussion (Misc queries) | |||
| Make excel run large spreadsheets faster | Excel Discussion (Misc queries) | |||
| Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
Threaded Mode
