backs up your book to a floppy disk Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub SaveWorkbookBackupToFloppyA() 
Dim awb As Workbook, BackupFileName As String, i As Integer, OK As Boolean 
    If TypeName(ActiveWorkbook) = "Nothing" Then Exit Sub 
    Set awb = ActiveWorkbook 
    If awb.Path = "" Then 
        Application.Dialogs(xlDialogSaveAs).Show 
    Else 
        BackupFileName = awb.Name 
        OK = False 
        On Error GoTo NotAbleToSave 
        If Dir("A:" & BackupFileName)  "" Then 
            Kill "A:" & BackupFileName 
        End If 
        With awb 
            Application.StatusBar = "Saving this workbook..." 
            .Save 
            Application.StatusBar = "Saving this workbook backup..." 
            .SaveCopyAs "A:" & BackupFileName 
            OK = True 
        End With 
    End If 
NotAbleToSave: 
    Set awb = Nothing 
    Application.StatusBar = False 
    If Not OK Then 
        MsgBox "Dosya Yedeklenemedi!", vbExclamation, ThisWorkbook.Name 
    End If 
End Sub

No	Macro Name
1	backs up your book to a floppy disk
2	backs up the workbook
3	book backup to floppy disk
4	floppy disk backup
5	excel operators hk
6	To print a text from excel in Excel
7	remove sheet / page protections
8	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.
9	back up your file to the desired folder
10	Write your name with file backup message box
11	lists the named cells in detail on the wb_names sheet / page
12	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.
13	right mouse on active sheet / page menu
14	Add menu to file edit bar delete
15	Refresh All Pivot Tables: A super fast method to refresh all pivot tables. Just run this code and all your pivot tables in your workbook will be refreshed in a single pull.
16	save the workbook to the "c:" section of your hard disk under the desired name
17	inserts months as sheet / pages Specifies days in detail
18	Who opened the file 2
19	a .bat file from a floppy disk
20	retrieve data from an encrypted closed file

Excel Free Macros (VBA)

Backs Up Your Book To A Floppy Disk

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords