Excel file size

  • Thread starter Thread starter richard123
  • Start date Start date
R

richard123

Please could somebody help.

I have some VBA code which takes a master template Excel workbook, i
manipulates the data and saves the file down as a different name. I
does this a number of times saving the files as different names as i
goes.

When the file saves, it doubles the size of the file. If I then ope
the file it has created and re-save the file it goes back to th
original size.

Does anybody know of anyway around this.

I have already made the master template as small as possible ie ctrl
end etc.

Thanks in advance
Richar
 
I've never seen this happen.

Any chance you're saving in that combo xl95/xl97+ file format?
 
Back
Top