Excel file size

[richard123]

Dave,

Thanks.

Unfortunatley I am saving in the correct format.
The really strange things is I open the file after the macro has save
it down, I then save it and it returns to the correct size.

Thanks
Richar

 

[Dave Peterson]

I've seen some posts that suggest that when strange things like this happen, it
maybe be because a workbook is corrupted.

If you create a small template workbook (from scratch) and run your code against
that, does the same thing happen?

And if not, I think I'd embellish the test and see if it occurs with a
completely rebuilt workbook.

(But it's a lot of work and it may not help. On the other hand, if your
workbook is corrupted, it may save you some blood, sweat and tears later when
things go horribly wrong.)

And (in a whisper): Have you tried just reopening the workbook and saving it
again in your code?

(That maybe putting a bandaid on a problem that comes back to bite you (yeah,
it's a mixed metaphor!))