| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the name of an unsaved workbook?
I have a small software which returns a worksheet with lots of data an
graphs, now the user might run it for different parameters withou really wanting to save them. My problem is that I would like to change the name of the newly create (And not yet saved) books so that the user knows which one is wha (Instead of having Book1, Book2 and so on). Is that possible? I tried setting Name property of the workbook but unfortunatelly it i read-only only before you save them (Apparently). Best Regards Noo -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change the name of an unsaved workbook?
The only way to change the name is to save it.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "NooK " wrote in message ... I have a small software which returns a worksheet with lots of data and graphs, now the user might run it for different parameters without really wanting to save them. My problem is that I would like to change the name of the newly created (And not yet saved) books so that the user knows which one is what (Instead of having Book1, Book2 and so on). Is that possible? I tried setting Name property of the workbook but unfortunatelly it is read-only only before you save them (Apparently). Best Regards NooK --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change the name of an unsaved workbook?
Can't be done without saving the workbook first.
-- Vasant "NooK " wrote in message ... I have a small software which returns a worksheet with lots of data and graphs, now the user might run it for different parameters without really wanting to save them. My problem is that I would like to change the name of the newly created (And not yet saved) books so that the user knows which one is what (Instead of having Book1, Book2 and so on). Is that possible? I tried setting Name property of the workbook but unfortunatelly it is read-only only before you save them (Apparently). Best Regards NooK --- Message posted from http://www.ExcelForum.com/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change the name of an unsaved workbook?
Thought as much. Really a pitty, I think this should be a nic
improvement from microsoft. Best Regards Noo -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook User had unsaved information disappear | Excel Worksheet Functions | |||
| How to recover unsaved workbook? | Excel Discussion (Misc queries) | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| How to reference unsaved workbook in functions???? | Excel Programming | |||
| Closing an Unsaved (but Changed) Workbook | Excel Programming | |||
![NooK[_43_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
