AW: Makro Zeilen ausblenden u. speich unter
19.09.2021 17:50:08
Alwin
Hallo Pet,
ich hoffe es hilft die weiter.
Option Explicit
Sub ZeilenAufNullUndSpeichern()
Dim i As Integer, X As Worksheet, Y As Worksheet
Set X = Tabelle3
Set Y = Tabelle4
For i = 25 To 39
If X.Cells(i, 1) = "" Then X.Rows(i).Hidden = True
Next i
For i = 15 To 29
If Y.Cells(i, 2) = "" Then Y.Rows(i).Hidden = True
Next i
SpeichernUnter
End Sub
Sub ZeilenZurueckSetzen()
Dim i As Integer, X As Worksheet, Y As Worksheet
Set X = Tabelle3
Set Y = Tabelle4
For i = 25 To 39
If X.Cells(i, 1) = "" Then X.Rows(i).Hidden = False
Next i
For i = 15 To 29
If Y.Cells(i, 2) = "" Then Y.Rows(i).Hidden = False
Next i
End Sub
Sub SpeichernUnter()
Dim Dateiname As String, Speichername As Variant, Stammverzeichnis As String, X As Worksheet, Y As Worksheet, KoTr As Range, KoTrNr As Long
Set X = Tabelle1
Set Y = Tabelle5
Set KoTr = Y.Columns(1).Find(X.Cells(2, 14), lookat:=xlWhole, LookIn:=xlValues, MatchCase:=True)
Stammverzeichnis = "C:\Users\pes\Documents\01 - LAP - Nachweise für Therapeuten\"
KoTrNr = KoTr.Row
Dateiname = Stammverzeichnis & X.Cells(1, 3) & "-" & Y.Cells(KoTrNr, 2) & "-out_1614.xls"
Speichername = Application.GetSaveAsFilename(Dateiname, "Micrsoft Excel-Dateien (*.xls),*.xls")
If Speichername False Then
ThisWorkbook.SaveAs Speichername
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Dateiname & ".pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False
Else
MsgBox "Abbruch durch Anwender"
End If
End Sub
Gruß Uwe