ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change the name of an unsaved workbook? (https://www.excelbanter.com/excel-programming/305810-change-name-unsaved-workbook.html)

NooK[_43_]

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


Bob Phillips[_6_]

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/




Vasant Nanavati

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/




NooK[_44_]

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



All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com