Changing the default name of added workbooks

[prajul89]

Hi,
I am creating a report in a completely new book by Workbooks.Add method and not saving it so that I can change its name while saving.
The default name of the books are "Book?" which I want to change to "Trial Balance".
Is it possible to do so??

 

[rs2k]

Maybe

Set NewBook = Workbooks.Add
With NewBook
        .SaveAs Filename:=MyPath & "\" & "Trial Balance.xls"
End With

HTH
Colin

 

[prajul89]

I don't want to save the file, I want user to save the file.
I just want to change the default name of the Workbook

 

[prajul89]

ActiveWorkbook.Name = "test.xlsx"
Even this can't be accepted as activeworkbook is a read only file.
Any suggestions please.....

 

[RoryA]

The only way to change the name is to save it, or base it on a template with the name you want (though you will still get a numeric suffix)

 

[prajul89]

And how do I do that?
How to base it on a template with the name I want?

 

[RoryA]

Create a workbook, save it as a template with whatever name you want. Then pass the full path of the template to your workbooks.add method

 

[prajul89]

cooool
Thanks for the Help!!!