Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing workbook name in macro
I want to change (in a macro) a workbook name before saving. Fo instance: the original file is opened as "test.xls", an InputBox ask for the extension (he _abc) and on saving the name should b "test_abc.xls". I don't want the original file to be overwritten. Ho can I achieve this -- Dutch7 ----------------------------------------------------------------------- Dutch76's Profile: http://www.hightechtalks.com/m82 View this thread: http://www.hightechtalks.com/t234349 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing workbook name in macro
With Activeworkbook
.saveas filename:= left(.name,len(.name)-4) & ib_value & ".xls" End With -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Dutch76" wrote in message ... I want to change (in a macro) a workbook name before saving. For instance: the original file is opened as "test.xls", an InputBox asks for the extension (he _abc) and on saving the name should be "test_abc.xls". I don't want the original file to be overwritten. How can I achieve this? -- Dutch76 ------------------------------------------------------------------------ Dutch76's Profile: http://www.hightechtalks.com/m829 View this thread: http://www.hightechtalks.com/t2343497 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
changing 08 workbook to 09 | Excel Discussion (Misc queries) | |||
Saving a sheet in a workbook as .csv but not changing workbook name | Excel Programming | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
changing name of workbook | Excel Programming |