Roncancio
Meubilair
- Lid geworden
- 24 mei 2005
- Berichten
- 8.257
Code:
Dim wBook As Workbook
On Error Resume Next
Set wBook = Workbooks("CENTRAL.XLSX")
If wBook Is Nothing Then CentFile = "C:\Temp\CENTRAL.XLSX"
If Dir(CentFile) <> "" Then Workbooks.Open CentFile
With Workbooks("CENTRAL.XLSX").Worksheets(1)
.Range("A1").AutoFilter Field:=3, Criteria1:=ThisWorkbook.Worksheets(1).Range("C2").Value
.Range("D2:D" & .UsedRange.Rows.Count).SpecialCells(xlCellTypeVisible).Value = 2
.Range("E2:E" & .UsedRange.Rows.Count).SpecialCells(xlCellTypeVisible).Value = Date
End With
Workbooks("CENTRAL.XLSX").Close SaveChanges:=True
Met vriendelijke groet,
Roncancio