Hi Tom,

I have a file that work add a new WB and save it to another directory,
but I have a problem with the size of that file is gained ... why ?
from 92kb to 6mb
Before saving I use :
Public Wb as Workbook

I use Wb in procedure1 and reuse Wb in procedure2,
I assumed that Public Wb is can be used from another procedure
during runtime ... is that right ?

I thought that before automation I've crashed the Excel memory or
temporary file, is it possible ?

Any help will be appreciated .... :)
Rgds,

Halim.