Reset workbook counter to "0"
 

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?

Reset workbook counter to "0"
 

What workbook counter?

--
HTH

Bob Phillips

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

"Ricardo" wrote in message
...
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?

Reset workbook counter to "0"
 

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

Charles
Bob Phillips wrote:
What workbook counter?

--
HTH

Bob Phillips

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

"Ricardo" wrote in message
...
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?

Reset workbook counter to "0"
 

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" wrote:

What workbook counter?

--
HTH

Bob Phillips

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

"Ricardo" wrote in message
...
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?

Reset workbook counter to "0"
 

I don't think that that is possible.

--
HTH

Bob Phillips

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

"Ricardo" wrote in message
...
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" wrote:

What workbook counter?

--
HTH

Bob Phillips

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

"Ricardo" wrote in message
...
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?