¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 16:57 ½s¿è
- Cells.Find(What:=".xls", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
- :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
- False, MatchByte:=False, SearchFormat:=False).Activate
- Selection.Copy
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- Cells.FindNext(After:=ActiveCell).Activate
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
½Æ»s¥N½X ¤W±¬O§Ú¿ý»sªº¥¨¶°
§Ú·Q§ä¥X¤u§@ªí¤¤¹ï·Ó¨ì¨ä¥LÀɮתº¤½¦¡µM«á¶K¤WÈ
§Ú·Q®M¥Î°j°éªº¤è¦¡¥h¶] §Ú¸Ó¦p¦óקï
©ÎªÌ¦³¨ä¥¦¤è¦¡¥i¥H¹F¨ì§Únªºµ²ªG
¤£·Qn¨C¦¸¶}Àɮ׳£¥X²{°Ý§Ún¤£n§ó·s³sµ²(¤S¤£½T©w¬Oþ¦U¤u§@ªí) |