Save A Dated And Undated Book With A Cell Name Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub range_date_save () Dim dName$ dName = Worksheets(1).Range("A1") dName = Format(dName, "mmdd") & ".xls" ActiveWorkbook.SaveAs dName End Sub Sub range_save() ThisWorkbook.SaveAs FileName:=Worksheets(1).Range("A1") End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 save a dated and undated book with a cell name 2 excel operators hk 3 dated copy 4 send alert e-mail from microsoft outlook 5 Undo cells with 0 6 Merge c1 cell with 3 numbers c2 from right save and open 7 Create a Content Table: Suppose you have over 100 worksheets in your workbook. And now it is hard to navigate. Do not worry that this macro code will save everything. When you run this code, you will create a new worksheet and create a & nbsp; will create a directory. 8 excel fonts 2 9 create shortcut to desktop 10 desktop icon creation 11 creates folder with book name save each sheet / page separately 12 Save the sheet / page to the desired location with the name in cell a1 13 Attendance Codes workbook-level tasks & nbsp; it will help you perform it easily and with minimal effort. & Nbsp; Create a Backup of a Current Workbook: This is one of the most useful macros that can help you save a backup file of a current workbook. Saves a backup file in the directory where your current file is saved. & Nbsp; It will also add the name of the file to the current date. 14 copy cells as images 15 sending email with macro 16 Creating a book with cell name c1 17 backups and saves the workbook (to the current directory) --- per-author 18 automatic image fetch 19 send list by excel 20 listbox entry to new book