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