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.

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.