2,503
社区成员




Application.ScreenUpdating = False
Sheets("XXXX").Select
Columns("A:G").Select
Selection.ClearContents
Dim bok As Workbook
Set bok = Workbooks.Open("XXXXXXXXXXXXXXXXX\Cross Support Name List.xlsm", ReadOnly:=True) '以只读方式打开工作簿。
Windows("Cross Support Name List.xlsm").Activate
Sheets("CrossSkill").Select
Range("E7").Select
Selection.AutoFilter
ActiveSheet.Range("$A$7:$O$199").AutoFilter Field:=6, Criteria1:="EU"
Range("C7:I1000").Select
Selection.Copy
Windows("Automatic Attandance Tool- 20191218.xlsm").Activate
Range("A1").Select
ActiveSheet.Paste