| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
naming a workbook the same as a cell entry
is it possible to automatically name a workbook the same as a cell entry when
i instruct the program to save the file? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
naming a workbook the same as a cell entry
If the name is, for example, at Range A1 in a Worksheet called Setup, you
could use this command: ThisWorkbook.SaveAs (Worksheets("SetUp").Cells(1, 1).Value) -- Adilson Soledade "des-sa" wrote: is it possible to automatically name a workbook the same as a cell entry when i instruct the program to save the file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date calculation across workbooks / Workbook naming question. | Excel Discussion (Misc queries) | |||
| Naming convention for workbook names | Excel Discussion (Misc queries) | |||
| Naming a new Excel workbook in a macro | Excel Worksheet Functions | |||
| Auto naming Tabs in a Workbook | Excel Discussion (Misc queries) | |||
| Workbook "Sheet" Naming | Excel Discussion (Misc queries) | |||
![des-sa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
