Home |
Search |
Today's Posts |
#1
|
|||
|
|||
worksheet size in bytes
Hi Everybody, is there any algorythm/function to know the size of given excel worksheet in byte? Tamas -- Tamas Nagy ------------------------------------------------------------------------ Tamas Nagy's Profile: http://www.excelforum.com/member.php...o&userid=28000 View this thread: http://www.excelforum.com/showthread...hreadid=475020 |
#2
|
|||
|
|||
I think you'd have to save the worksheet in question as its own workbook.
While you could add up all the characters in all the cells that's only a part of the picture given that many other things are part of the sheet, formatting for instance. -- Jim "Tamas Nagy" wrote in message ... | | Hi Everybody, | | is there any algorythm/function to know the size of given excel | worksheet in byte? | | Tamas | | | -- | Tamas Nagy | ------------------------------------------------------------------------ | Tamas Nagy's Profile: http://www.excelforum.com/member.php...o&userid=28000 | View this thread: http://www.excelforum.com/showthread...hreadid=475020 | |
#3
|
|||
|
|||
Thanks for the reply, the problem is that I have a very large excel file (mainly because of the formats), and I have to choose the biggest one, trying to reduce them. The file has more than 300 sheets, so the "manual" saving as a sole sheet is not feasible. That is the reason why I have to get a algorythmical solution in code (the savings requires lots of time). -- Tamas Nagy ------------------------------------------------------------------------ Tamas Nagy's Profile: http://www.excelforum.com/member.php...o&userid=28000 View this thread: http://www.excelforum.com/showthread...hreadid=475020 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
How do I apply a default size to all comments in Excel worksheet? | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |