backup 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)

Backup

Online Excel and Excel Macro (VBA) Courses

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Private Sub CommandButton3_Click()
Dim dsy
dsy = InputBox("Lütfen LEAD TIME'a ait ayın adını giriniz?", "Lead Time Dosyası Oluşturma", Format(Now, "mmmm_yyyy"))
If dsy = Cancel Then Exit Sub
On Error GoTo 10
MkDir "C:LEAD TİME" & dsy
Set NewBook = Workbooks.Add
    With NewBook
        .SaveAs "C:LEAD TİME" & dsy & "" & "Lead_time_" & dsy & ".xls"
    End With
    Windows("LEAD TİME.xls").Activate
    Cells.Select
    Selection.Copy
    Windows("Lead_time_" & dsy & ".xls").Activate
    ActiveSheet.Paste
    Range("A2").Select
    Range("Z1:AG9").Select
    Application.CutCopyMode = False
    Selection.Delete Shift:=xlToLeft
    Range("A2").Select
    ActiveWorkbook.Save
    ActiveWorkbook.Close
    Windows("LEAD TİME.xls").Activate
    Range("A2").Select
    ActiveWorkbook.Save
Unload UserForm1
Exit Sub
10:
MsgBox "Dosya ismini kontrol edip tekrar deneyiniz.", vbExclamation, "UYARI!!!!!!!"
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	file backup
2	dated backup
3	date and time backup
4	takes dated backup to current folder
5	backup encrypting
6	change password with save as
7	Get dated backup 1
8	dated backup take 2
9	save each sheet / page separately as a book
10	Write your name with file backup message box
11	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.
12	save as macro only save the specified sheet / page
13	book gets backup dated this day when opening
14	backups and saves the workbook (to the current directory) --- per-author
15	floppy disk backup
16	book backup to floppy disk
17	backup
18	backs up the workbook
19	backs up your book to a floppy disk
20	book backup

Excel Free Macros (VBA)

Backup

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords