That's the way Excel works.
If you create a new workbooks, it increments the number each time, only
resetting when Excel closes.
Is it really such a big deal if you are only .SaveAs anyway ?

NickHK

"whylite" wrote in message
...
Thanks for the response. There has to be a way rather than to close right
out of excel and reopen I will keep looking thank you.
--
Thanks!
Shane W


"NickHK" wrote:

If it's really that important to you, the only way I know is to close
Excel
and reopen it.
Not really worth it.
You could make a template called "Book1.xlt" and open that each time if
you
really want to keep "Book1.xls" everytime.

NickHK

"whylite"
...
I was wondering if there is any way to reset the new book count in
excel
with
a macro. Currently I have a macro that creates a new book, adds data
to
it,
and then saves it with a new name. What I have noticed is that if I
run
the
macro a few times the new book comes up as book1, book2, book3. Is
there
any
way a macro could reset the counter so that every time Book1 comes up.
--
Thanks!
Shane W