| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I reset the default pie chart label "Other" to "Equity"? | Charts and Charting in Excel | |||
| how do i reset the default from "general" to "number" | Excel Discussion (Misc queries) | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
| "Reset" a workbook | Excel Programming | |||
Linear Mode
