Opening a new workbook via a macro
When recording a macro and opening a new workbook it seems to just add 1 to
the Book no ( eg Book1,Book2 etc) if you've already opened a blank workbook- I need to always open Book1 when opening via a macro - is this possible? Thanks |
Opening a new workbook via a macro
hi
don't think so. deep in the background of excel's programming, excel keeps track of how many blank workbooks it has added. this is a counter that does not reset when you delete or rename the blank workbook. It does reset to zero when you close excel. and the default workbook name is book & counter. excel does the same thing with newly added sheets. and i don't think you can change the name of wth newly added workbook untill you have saved it once. regards FSt1 "Chris Maddogz" wrote: When recording a macro and opening a new workbook it seems to just add 1 to the Book no ( eg Book1,Book2 etc) if you've already opened a blank workbook- I need to always open Book1 when opening via a macro - is this possible? Thanks |
Opening a new workbook via a macro
Thanks for that I did notice that after closing Excel & reopening it the
default workbook became Book1 so I guess thats the way. "FSt1" wrote: hi don't think so. deep in the background of excel's programming, excel keeps track of how many blank workbooks it has added. this is a counter that does not reset when you delete or rename the blank workbook. It does reset to zero when you close excel. and the default workbook name is book & counter. excel does the same thing with newly added sheets. and i don't think you can change the name of wth newly added workbook untill you have saved it once. regards FSt1 "Chris Maddogz" wrote: When recording a macro and opening a new workbook it seems to just add 1 to the Book no ( eg Book1,Book2 etc) if you've already opened a blank workbook- I need to always open Book1 when opening via a macro - is this possible? Thanks |
All times are GMT +1. The time now is 03:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com