Private Sub AddSheet()
Sheets(1).Select
Sheets.Add
Sheets(1).Name = Date & "-" & Replace(Time, ":", ".")
End Sub
Private Sub SaveWorksheet()
SFilename = "f:\group\" & Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4) & " - " & Date & " - " & Replace(Time, ":", ".") & ".xls"
ActiveWorkbook.SaveAs Filename:=SFilename, _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub
Private Sub SaveWorksheet()
Dim Folder As String
Dim FileName As String
Dim FilePath As String
Folder = "F:\group\crpub\Neu\"
FileName = Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4) & "_" & Date & "_" & Format(Time, "HH.MM") & ".xls"
FilePath = Folder & FileName
ActiveWorkbook.SaveAs FileName:=FilePath, _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub
Private Sub SaveWorksheet()
Dim Folder As String
Dim FileName As String
Dim FilePath As String
Folder = "F:\group\crpub\Neu\"
FileName = ("Stückzahlen") & "_" & Date & "_" & Format(Time, "HH.MM") & ".xls"
FilePath = Folder & FileName
ActiveWorkbook.SaveAs FileName:=FilePath, _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
MsgBox "Bitte nur über Schaltfläche speichern!"
End Sub
Die erweiterte Suchfunktion hilft dir, gezielt die besten Antworten zu finden
Suche nach den besten AntwortenEntdecke unsere meistgeklickten Beiträge in der Google Suche
Top 100 Threads jetzt ansehen