- ©«¤l
- 234
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 276
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-7
- ³Ì«áµn¿ý
- 2021-10-7
|
¨Ï¥ÎVBµ{¦¡Copy Excel(A)ªº¸ê®Æ¨ìExcel(B)
¦ý»Ý¥ý¿z¿ïExcel(A)ªº¸ê®Æ,¥Ø«e¥u¯à¦bµ{¦¡¸Ì¼g¤J¹w¿z¿ïªº¤é´Á
½Ð°Ýn¦p¦ó±NCriteria1:=">=2012/11/27"ªº¤é´Á§ï¦¨°õ¦æ®É¥ý¸ß°Ý¹w¿z¿ïªº¤é´Á,©Î¦b¨ä¥L¦ì¸m¥ý¶ñ¤J¤é´Á
µM«áµ{¦¡·|±N¤é´Á±a¤J¿z¿ï±ø¥ó
Source = Application.GetOpenFilename
With Workbooks.Open(Source)
.Sheets(1).Select
Rows("1:1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">=2012/11/27", Operator:=xlAnd
.Sheets(1).Range("A:M").Copy ThisWorkbook.Sheets(2).Range("A1")
.Close
End With |
|