Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rename a group of spreadsheets in a workbook | Excel Discussion (Misc queries) | |||
Auto Rename Excel Sheets in Workbook | Excel Worksheet Functions | |||
Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
my colors change in my workbook when I open another workbook | Excel Discussion (Misc queries) | |||
Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) |