Workbook name

  • Thread starter Thread starter Gilbert Tordeur
  • Start date Start date
G

Gilbert Tordeur

Hello,

How is it possible to give a name to a new workbook without saving it?

Explanation: my web application is creating a new Excel sheet and prints it
to a PDF file that takes the name of the workbook. I do not need to save the
workbook but it is the only way I know today to give it a specific name.

Thank you,
Gilbert
 
The only way to change the name of the workbook is to save it but are you
sure the name used is coming from the workbook name or its window's caption?
They are usually the same but don't have to be. You can change the caption
with a macro:

activewindow.caption = "abc"

--
Jim
| Hello,
|
| How is it possible to give a name to a new workbook without saving it?
|
| Explanation: my web application is creating a new Excel sheet and prints
it
| to a PDF file that takes the name of the workbook. I do not need to save
the
| workbook but it is the only way I know today to give it a specific name.
|
| Thank you,
| Gilbert
|
|
 
Back
Top