Public Sub OpslBestand()
Dim NieuwFact As Variant
'kopiëren document als nieuwe factuur
ActiveSheet.Copy
NieuwFact = "\\SBS2011\RedirectedFolders\pepijn\My Documents\Pepijn\Werkorders\Werkorder" & Range("B3").Value & ".xlsx"
ActiveWorkbook.SaveAs NieuwFact, FileFormat:=xlOpenXMLWorkbook
ActiveWorkbook.Close
With Sheets("werkorders")
lastrow = Sheets("werkorders").Range("A:I").Find("*", _
SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
.Cells(lastrow + 1, "A") = Sheets("Leeg Werkorder").Range("B3")
.Cells(lastrow + 1, "A").Hyperlinks.Add .Cells(lastrow + 1, "A"), "\\SBS2011\RedirectedFolders\pepijn\My Documents\Pepijn\Werkorders\Werkorder" & Range("B3").Value & ".xlsx"
.Cells(lastrow + 1, "B") = Sheets("Leeg Werkorder").Range("B2")
.Cells(lastrow + 1, "C") = Sheets("Leeg Werkorder").Range("B5")
.Cells(lastrow + 1, "D") = Sheets("Leeg Werkorder").Range("B7")
.Cells(lastrow + 1, "E") = Sheets("Leeg Werkorder").Range("B6")
.Cells(lastrow + 1, "F") = Sheets("Leeg Werkorder").Range("E4")
.Cells(lastrow + 1, "H") = Sheets("Leeg Werkorder").Range("B10")
.Cells(lastrow + 1, "G") = Sheets("Leeg Werkorder").Range("B9")
.Cells(lastrow + 1, "I") = Sheets("Leeg Werkorder").Range("A11")
MsgBox "Werkorder succesvol verwerkt!", vbInformation, "Goed gedaan"
Range("B3").Value = Range("B3").Value + 1
Range("B4:C4").ClearContents
Range("B5:C8").ClearContents
Range("B9:C10").ClearContents
Range("D4:q32").ClearContents
Range("A13:C15").ClearContents
Range("A15:B33").ClearContents
End With
With Sheets("planning")
lastrow = Sheets("planning").Range("A:I").Find("*", _
SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
.Cells(lastrow + 1, "A") = Sheets("Leeg Werkorder").Range("B10")
.Cells(lastrow + 1, "B") = Sheets("Leeg Werkorder").Range("B5")
.Cells(lastrow + 1, "C") = Sheets("Leeg Werkorder").Range("B9")
.Cells(lastrow + 1, "D") = Sheets("Leeg Werkorder").Range("B7")
.Cells(lastrow + 1, "E") = Sheets("Leeg Werkorder").Range("A13")
.Cells(lastrow + 1, "F") = Sheets("Leeg Werkorder").Range("A11")
End With
End Sub
in de `12e regel schrijf ik de hyperlink naar zijn plek toe.