While I haven't played with these much myself, it sounds like you could save
your "base file" as a Template and then just use it when you needed it (each
month)... when you Save the file and then close it, the base file would
remain unchanged and your data would be in the file you saved out to. Maybe
you would want to test this concept out on a sample "base file" and see it
this works for you.

--
Rick (MVP - Excel)


"BillCPA" <Bill @ UAMS wrote in message
...
I have a 'Base' file that I start this particular process with - lots of
macros and formulas. I pull in a couple of additional files, do some data
manipulation - delete rows, insert columns, add worksheets, etc. - and
then
write out a new file with info that goes into the general ledger.

I want the 'Base' file to be the same each month when I start the
processing, so once I get into the process, I save the 'Base' file with a
different name. Once I have created my output file for the GL, I no
longer
need the file I'm working from, so I want to delete it. I used to save it
in
case I needed to reference it, but never needed to, so now I just delete
it.
If I did need it, I can always re-run the process - it only takes fifteen
seconds or so.

--
Bill @ UAMS


"Rick Rothstein" wrote:

You said you wanted to "delete" the workbook when you close it. To me,
delete means remove it from the hard drive so it no longer exists. The
code
Tim gave you (which you appeared to say does what you want) uses the Kill
function which does exactly that... it removes the file from the hard
drive.
My question is this... what useful thing is the workbook doing that you
only
need it once and never again (remember, it is deleted after being used
one
time)?

--
Rick (MVP - Excel)


"BillCPA" <Bill @ UAMS wrote in message
...
I'm not sure what exactly you are asking.

I execute 'Application.Quit' from a menu Exit button, which I assume
sets
a
process in motion to close all files and exit Excel, no matter whether
the
current workbook still exists or not.

--
Bill @ UAMS


"Rick Rothstein" wrote:

Just for my own curiosity, what function did the workbook perform that
it
can be deleted from existence when it is closed?

--
Rick (MVP - Excel)


"BillCPA" <Bill @ UAMS wrote in message
...
Is it possible for a workbook to delete itself when it closes?

--
Bill @ UAMS