| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook add, reqest name
I want a macro to add a workbook using: -
Workbooks.Add But then uses a cell (eg A1) to create its name with a descrtiptio afterwards. Eg a1 = January Description is " - Monthly Stats" Any body got the answer -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook add, reqest name
As I understand it, a workbook does not get a name until it is saved.
-- Rob van Gelder - http://www.vangelder.co.nz/excel "ianripping " wrote in message ... I want a macro to add a workbook using: - Workbooks.Add But then uses a cell (eg A1) to create its name with a descrtiption afterwards. Eg a1 = January Description is " - Monthly Stats" Any body got the answer? --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook add, reqest name
ok is it possible to save the workbook with a name entered into a cell?
also can you use a cell refernce to rename a sheet name -- Message posted from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook add, reqest name
Filename in A1
Sheetname in A2 Sub test() Application.DisplayAlerts = False ThisWorkbook.SaveAs "C:\" & Range("A1").Value & ".xls" Application.DisplayAlerts = True Worksheets(1).Name = Range("A2").Value End Sub DisplayAlerts prevents the warning "a file already exists with this name" -- Rob van Gelder - http://www.vangelder.co.nz/excel "ianripping " wrote in message ... ok is it possible to save the workbook with a name entered into a cell? also can you use a cell refernce to rename a sheet name? --- Message posted from http://www.ExcelForum.com/ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook add, reqest name
|
| 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 | |||
| Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
![ianripping[_39_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
