[RESOLVED] Renaming a Workbook

[Lemon Lime]

I have created an EXCEL appliction:

Set ExcelApp = CreateObject("Excel.Application")
'ExcelApp.Visible = False
Set ExcelBook = ExcelApp.workbooks.Add

And I realy want to rename the book to more than BOOK1

Is it possible?

[DKenny]

Do you want to rename it when you save?

[billhuard]

the best way to rename a workbook is when you save it

ExcelBook.SaveAs Filename:="c:\WhatEverYouWant.xls"

[Lemon Lime]

I want it to have a name before saving. If it's possible, then name should be changed when the workbook has been created.
Thus, the end user will not have to wonder for a filename.

[RobDog888]

Create a template workbook named as you want and refer to it when you open it via code. It will append a 1 or whatever count of that workbook are open. Just like Word does with its Document1 etc.

[Lemon Lime]

Can I create the template in runtime without saving it?

[RobDog888]

Nope.

You can just create a blank new document and then save it to the disk as the filename you want and then reopen it for displaying to the user. Its about the only way as the .Name property of the document is read only.

[Lemon Lime]

10X