Sub hsv()
Application.ScreenUpdating = False
With Sheets("blad1")
If IsError(Evaluate("'" & Format(.Range("K4"), "mmmm yy") & "'!A1")) Then Sheets.Add(, Sheets(Sheets.Count)).Name = Format(.Range("k4"), "mmmm yy")
.ExportAsFixedFormat 0, "c:\temp\" & .Range("k4").Value, , , , , , -1
Application.Wait DateAdd("s", 1, Now)
.Range("A1:N30").Copy
Sheets(Format(.Range("K4"), "mmmm yy")).Rows(1).Resize(30).Insert xlDown
Sheets(Format(.Range("K4"), "mmmm yy")).Cells(1).PasteSpecial 12
.Range("c8:i8") = Sheets(Format(.Range("K4"), "mmmm yy")).Range("c10:i10").Value
.Range("k8:n8") = Sheets(Format(.Range("K4"), "mmmm yy")).Range("k10:n10").Value
With CreateObject("Outlook.Application").CreateItem(0)
.To = ""
.Subject = "Machinekamerrapport"
.attachments.Add "c:\temp\" & Sheets("blad1").Range("k4").Value & ".pdf"
.display '(voor directe versturen gebruik je) .send
End With
Do
On Error Resume Next
Kill "c:\temp\" & .Range("k4").Value & ".pdf"
Loop While Err.Number = 0
.Range("k9").Resize(, 4).ClearContents
.Range("c10").Resize(, 8).ClearContents
.Range("b12:n20,b22:n30").ClearContents
End With
End Sub