book backup to floppy disk Free Excel Macros (VBA) | Excel Programs

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

Book Backup To Floppy Disk

Online Excel and Excel Macro (VBA) Courses

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 "Backup Copy Not Saved!", vbExclamation, ThisWorkbook.Name
    End If
End Sub

Report problem with this macro

Report error

ALL MACROS

Youtube Channel
The following macros may be useful for you.

Similar Results
No	Macro Name
1	book backup to floppy disk
2	floppy disk backup
3	backs up your book to a floppy disk
4	backs up the workbook
5	book backup
6	book backup
7	backup
8	excel operators hk
9	backups and saves the workbook (to the current directory) --- per-author
10	remove sheet / page protections
11	save the workbook to the "c:" section of your hard disk under the desired name
12	learning harddiskin free space etc ..
13	takes dated backup to current folder
14	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.
15	a .bat file from a floppy disk
16	Write your name with file backup message box
17	dated backup take 2
18	Get dated backup 1
19	Who opened the file 2
20	book gets backup dated this day when opening

Excel Free Macros (VBA)

Book Backup To Floppy Disk

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords