How to open a new workbook and rename the workbook?

[pokdbz]

I need to know how to open a new workbook and then rename the workbook?

 

[Kevin B]

Click FILE and select SAVE or press <CTRL> + S

 

[pokdbz]

Sorry was trying to write VBA code for this.

I have Workbooks.Add but I cannot figure out how to rename the open Workbook.

 

[Dave Peterson]

Workbooks are "renamed" by saving them.

So you'll have to use something like:

dim NewWkbk as workbook
set newwkbk = workbooks.add
newwkbk.saveas filename:="C:\whateveryouwanthere.xls", _
fileformat:=xlworkbooknormal