Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to evaluate the size of each worksheet in a workbook?
I have a 30+ worksheets in a workbook that is to big....
I would like to know which one are the top memory eater, so I can concentrate my effort on these one. Thanks for your help |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
How to evaluate the size of each worksheet in a workbook?
The code below will save each worksheet to a sperate file using the sheet
name as the filename. hen compare the filesizes to see which sheets are the largest. Sub CopySheets() ' ' Macro2 Macro ' Macro recorded 8/22/2007 by Joel ' ' Const SavePath = "c:\temp\" testnumber = 1 For Each ws In Worksheets Worksheets(ws.Name).Copy ActiveWorkbook.SaveAs Filename:=SavePath & ws.Name ActiveWorkbook.Close testnumber = testnumber + 1 Next ws End Sub " wrote: I have a 30+ worksheets in a workbook that is to big.... I would like to know which one are the top memory eater, so I can concentrate my effort on these one. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase in the Size of the Excel WorkBook | Excel Discussion (Misc queries) | |||
can i size an Excel workbook window's opening size? | Excel Discussion (Misc queries) | |||
My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
Size of a Workbook | Excel Discussion (Misc queries) | |||
workbook size and calculations | Excel Worksheet Functions |