Reset workbook counter to "0"

[Guest]

I am running macro which creates multiple workbooks. I wnat to reset my
workbook counter, without closing and re-opening Excel. Is there VB script to
include in my macro to do this?

 

[Bob Phillips]

What workbook counter?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Die_Another_Day]

I'm guessing he means the one that controls the WB name (Book1, Book2,
Book3, etc..) Can this even be done?

Charles

 

[Guest]

Yes Bob and D-A-D The workbook counter that Excel defaults to use when you
start it up. I need to be able to reset back to Book1.xls, but I don't want
to close Excel and have to re-open it. Thanks much!

 

[Bob Phillips]

I don't think that that is possible.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)