Shane,
I'll gladly not waste any more of more on my time on your inane drivel.

NickHk

"whylite" ...
Do me a Favor NickHK. Don't respond to any of my posts. It's apparent
that
you have no idea what I am asking and your responses are not helpful.
--
Thanks!
Shane W


"NickHK" wrote:

If all your code only works on the basis that Excel new books are always
called 'Book1", then there is something wrong with your logic and/or
code.
It really should not any difference what the name is.

You can ActiveWorkbook, ThisWorkbook or Set your own object reference to
the
new book, so this should not be a concern.

NickHK

"whylite" wrote in message
...
I have tried that but you can only do the action once unless you close
excel
completely the counter goes to book2 if you do the action again. Hence
the
reason I was wondering how I can reset the counter. Currently I have
set
my
macro up to only do the action once so that an error does not occur.
That
will have to do until I figure out another way.
--
Thanks!
Shane W


"NickHK" wrote:

Why not change it open a template called Book1 (or whatever) instead
of
Workbooks.Add.
Then oyu always have the same.
The "template" doesn't have to contain anything special, just the
name.

NickHK

"whylite"
...
I have a change link macro. If the current link is to book1
(unknown
destination) then the macro opens up a new book (book1) in order to
execute
properly. This is the only way to make it work. I could go into
the
change
link in the tool bars and do it that way successfully every time
but I
have
many individuals using my spreadsheets that have limited knowledge
in
excel.
As it stands right now one can only change link once with my macro.
If
they
open another file and try to change the link book2 comes up and the
change
link fails. That's why I would like to figure out a way to reset
the
counter.
--
Thanks!
Shane W


"NickHK" wrote:

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