Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to add a workbook the rename it
Hi Excel users and experts
Excel 2002 From help I get the following to name a workbook. It errors out with a yellow line. I tried the macro recorder but it give the file name and a whole string of stuff I don't want using Save As. Am I missing a menu item that will allow me to record a workbook name change??? (The AutoFit is just part of the code to format a sheet) Columns("A:K").Columns.AutoFit Workbook.Names.Add Name:="The Newest" Thanks, Howard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to add a workbook the rename it
What you got from the macro recorder is going to be closer to what you want.
You can not just change the name of a file. You need to save it. The first time you save something it is by default a save as operation... dim wbkNew as workbook set wbknew = workbooks.add with wbknew .saveas "C:\Myfile.xls" .close 'or whatever you want to do with then new book end with -- HTH... Jim Thomlinson "L. Howard Kittle" wrote: Hi Excel users and experts Excel 2002 From help I get the following to name a workbook. It errors out with a yellow line. I tried the macro recorder but it give the file name and a whole string of stuff I don't want using Save As. Am I missing a menu item that will allow me to record a workbook name change??? (The AutoFit is just part of the code to format a sheet) Columns("A:K").Columns.AutoFit Workbook.Names.Add Name:="The Newest" Thanks, Howard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to add a workbook the rename it
This is from the VBA help file:
The Name property returns the workbook name. You cannot set the name by using this property; if you need to change the name, use the SaveAs method to save the workbook under a different name. "L. Howard Kittle" wrote: Hi Excel users and experts Excel 2002 From help I get the following to name a workbook. It errors out with a yellow line. I tried the macro recorder but it give the file name and a whole string of stuff I don't want using Save As. Am I missing a menu item that will allow me to record a workbook name change??? (The AutoFit is just part of the code to format a sheet) Columns("A:K").Columns.AutoFit Workbook.Names.Add Name:="The Newest" Thanks, Howard |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to add a workbook the rename it
Thanks Jim and JL, that sheds some light on it.
Regards, Howard "L. Howard Kittle" wrote in message ... Hi Excel users and experts Excel 2002 From help I get the following to name a workbook. It errors out with a yellow line. I tried the macro recorder but it give the file name and a whole string of stuff I don't want using Save As. Am I missing a menu item that will allow me to record a workbook name change??? (The AutoFit is just part of the code to format a sheet) Columns("A:K").Columns.AutoFit Workbook.Names.Add Name:="The Newest" Thanks, Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open a new workbook and rename the workbook? | Excel Discussion (Misc queries) | |||
Rename worksheets of workbook - Error code | Excel Programming | |||
Rename a new workbook | Excel Programming | |||
How can I rename a Workbook? | Excel Programming | |||
Rename a workbook! | Excel Programming |