dated copy 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)

Dated Copy

Online Excel and Excel Macro (VBA) Courses

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Public Sub Dateikopie()
    Dim InI As Integer
    Workbooks.Add
    With ThisWorkbook                                                   ' Datei mit Code
        ActiveWorkbook.SaveAs .Path & "Kopie_von" & ThisWorkbook.Name  ' neue Datei Workbooks.Add
        For InI = .Worksheets.Count To 1 Step -1                        ' Anzahl Register in ThisWorkbook
            Sheets.Add
            .Worksheets(InI).Cells.Copy
            With ActiveWorkbook.ActiveSheet.Cells
                .PasteSpecial Paste:=xlPasteValues      ' Werte
                .PasteSpecial Paste:=xlFormats          ' Formate
            End With
            ActiveWorkbook.ActiveSheet.Name = .Worksheets(InI).Name
        Next InI
        Application.CutCopyMode = False         'Zwischenspeicher löschen
        Application.DisplayAlerts = False
        Worksheets(ActiveWorkbook.Worksheets.Count).Delete
        Application.DisplayAlerts = True
        MsgBox "Reine Datentabelle gespeichert als: " & .Path & "Kopie_von" & ThisWorkbook.Name
        ActiveWorkbook.Close True
    End With
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	formula and dated copy
2	dated copy
3	dated backup
4	takes dated backup to current folder
5	Get dated backup 1
6	dated backup take 2
7	Select and delete columns for a1b1c1d1 (delete with hold)
8	copies the sheet / page and creates a sheet / page dated yesterday and assigns the information into it
9	book gets backup dated this day when opening
10	to assign a value to another sheet / page without selecting a formulated cell
11	excel operators hk
12	save a dated and undated book with a cell name
13	Copy and paste formats of cells
14	giving sheet / page insertion sequence number
15	you specify the sheet / page copy
16	pdf preview
17	active cell printing
18	printing and prompting
19	opens and copies the selected word document
20	create sheet / pages based on data and copy lines

Excel Free Macros (VBA)

Dated Copy

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords