Huge file size doesnt make any sense

[Skagga5]

Hi All

I have got a VBA model that performs our monthly reporting, I then have a command button on an Userform which allows the user to email four of the sheets in the workbook, will refer to this as the extracted workbook.

The masterfile is 18MB, the extracted workbook that gets emailed is 3MB big, when I copy each individual sheet of the extracted workbook into a new workbook each of the four files are 3MB. If I delete my four sheets in the extracted workbook and I am effectively left with an empty workbook the file size is still 2.7Mb. Somewhere something is hiding that is causing this workbook size to be overly excessive.

Any help on how I can reduce the file size would be greatly appreciated.

regards

 

[RoryA]

Thanks Mark. I have a feeling that something may have changed in our Firewall at work!

 

[Skagga5]

Thank you very much for all the replies.

I have added the below code to clear all the names which have resolved the issue.
<code class="vb keyword">Dim</code> <code class="vb plain">xName </code><code class="vb keyword">As</code> <code class="vb plain">Name</code>
<code class="vb keyword">For</code> <code class="vb keyword">Each</code> <code class="vb plain">xName </code><code class="vb keyword">In</code> <code class="vb plain">Application.ActiveWorkbook.Names</code>
<code class="vb spaces"> </code><code class="vb plain">xName.Delete</code>
<code class="vb keyword">Next</code>