I've had success with a macro that moves a specific sheet to a new
workbook and names that file with the contents of a particular cell. I
have only two small problems.

1. I need to add the date to the file name so that if the particular
cell that names the file is "Acme", then the new file would be named
"Acme 5-26-06"

2. With my current code, the new file is saved just fine, but it still
leaves an additional book open. In other words, I have the Master
Workbook from which the code will run and create "Book 2". From that,
the code Saves As "Book 2" with the name from that specific cell. It
automatically closes the new book, but leaves "Book 2" open. Is there
any way to make that close automatically?

Thanks to all.