| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
close file - open and save
hi,
i have very large file(~13000) i did some conditional formats deletion via macro. i also saved the file via macro. i noticed that the file size was reduced(~9500). but if i open the reduced file and close with save it size becomes even smaller (~8000). i believe there is a way to implement the last reduction via code(and not open&close), but i do not know how...please advice. thanks, -- Miri Tz. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
close file - open and save
Maybe this will give some insights:
http://www.contextures.com/xlfaqApp.html#Unused -- Regards, Tom Ogilvy "Miri" wrote: hi, i have very large file(~13000) i did some conditional formats deletion via macro. i also saved the file via macro. i noticed that the file size was reduced(~9500). but if i open the reduced file and close with save it size becomes even smaller (~8000). i believe there is a way to implement the last reduction via code(and not open&close), but i do not know how...please advice. thanks, -- Miri Tz. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open, Save and close Excel 2007 file with a cmd command | Excel Discussion (Misc queries) | |||
| Close & save a file at set time only IF the file is open | Excel Programming | |||
| Auto Open file VBA Refresh MS Query Save Close | Excel Programming | |||
| Open excel file, enter values, save & close | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Linear Mode
