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
|
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Excel 2010 Table not showing in Access 2010 Import List 0
Copy a worksheet to a new workbook 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Protect workbook for Windows option is grayed out in Excel 2013 3
excel sheet name 2
Newbie for starters with excel, I am needing to transfer info fromsheet2 to the universe sheet. 1
Excel Macro to un-mute Audio/speakers. 15

Back
Top