I have written some code to automate some calculations at work.
It all works fine but at the end of the calculation the file size is 7.5megs. I use ActiveWorkbook.Save at the end (of 31 pages of code) to save the file.
However, when I re-open the file and press save again ( I do nothing else just open it and press save) the file size shrinks to 6.6 megs.
Has anyone come across this before or do you know why it is happening.
Like I said I dont do anything just open it and press save and it shrinks.
I use Activeworkbook.SaveAs and ActiveWorkbook.Save but it still wont save as the smaller size.
Help anyone?!?!?!?