View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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.