backs up the workbook 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)

Backs Up The Workbook

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 "Dosya Yedeklenemedi!", 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	backs up the workbook
2	backs up your book to a floppy disk
3	excel operators hk
4	To print a text from excel in Excel
5	save as macro only save the specified sheet / page
6	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.
7	backup
8	excel crack
9	Track and Report User Changes in an Excel worksheet or workbook
10	remove sheet / page protections
11	back up your file to the desired folder
12	Get dated backup 1
13	Write your name with file backup message box
14	dated backup take 2
15	book gets backup dated this day when opening
16	backups and saves the workbook (to the current directory) --- per-author
17	lists the named cells in detail on the wb_names sheet / page
18	book backup to floppy disk
19	floppy disk backup
20	book backup

Excel Free Macros (VBA)

Backs Up The Workbook

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords