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 |
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 |