How to open a new workbook and rename the workbook?
 

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

How to open a new workbook and rename the workbook?
 

Click FILE and select SAVE or press <CTRL + S
--
Kevin Backmann


"pokdbz" wrote:

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

How to open a new workbook and rename the workbook?
 

Sorry was trying to write VBA code for this.

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

"Kevin B" wrote:

Click FILE and select SAVE or press <CTRL + S
--
Kevin Backmann


"pokdbz" wrote:

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

How to open a new workbook and rename the workbook?
 

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


pokdbz wrote:

Sorry was trying to write VBA code for this.

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

"Kevin B" wrote:

Click FILE and select SAVE or press <CTRL + S
--
Kevin Backmann


"pokdbz" wrote:

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

--

Dave Peterson