Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rename a workbook using a macro
I am trying to automate workbook saving, and I want each workbook to take
it's name from the word typed into the merged cell range A1:K1. I cannot get this to work through simple macro-recording action, and VB editing has got me nowhere! Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
rename a workbook using a macro
Jamesmsv, here is one way,
Sub SaveAsSub() ActiveWorkbook.SaveAs Filename:=Range("A1").Value & ".xls" End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Jamesmsv" wrote in message ... I am trying to automate workbook saving, and I want each workbook to take it's name from the word typed into the merged cell range A1:K1. I cannot get this to work through simple macro-recording action, and VB editing has got me nowhere! Any ideas? |
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 a new workbook | Excel Programming | |||
How can I rename a Workbook? | Excel Programming | |||
Rename a workbook! | Excel Programming | |||
Workbook, worksheet rename | Excel Programming |