"Robert Melbo" wrote in message
...
Is there a way to create a random/unique workbook name in Excel that
can be created by a macro at the beginning, the macro continues on
with its chores, and then, at the end, deletes that workbook? The
workbook is temporary in nature and does not need to exist after the
macro executes.


Why would you want to do this ?

If you open an Excel session you get a workbook who's name
defaults to Book1 but if you dont save it when you close
the session it never gets written to disk anyway.

If you really want a unique name for the workbook generate
a GUID

http://support.microsoft.com:80/supp...NoWebContent=1

Keith