edmoor
Inventaris
- Lid geworden
- 8 sep 2000
- Berichten
- 39.712
- Besturingssysteem
- Windows XP, 7, 10, 11-23H2
- Office versie
- Office 365
Dan maak je er dit van:
Code:
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
With Sheets("Blad1")
.Visible = True
Fname = "C:\Test\Jaar\" & .Range("E1") & .Range("G1") & .Range("H1") & ".pdf"
.Range("A1:H18").ExportAsFixedFormat 0, Fname
.Range("A2:H18").ClearContents
.Visible = False
End With
Application.ScreenUpdating = True
End Sub
Laatst bewerkt: