- ©«¤l
- 10
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-11-23
- ³Ì«áµn¿ý
- 2012-11-27
|
ɦ¹ÃD¤@°Ý
¦pªG¥un¶×¤JM1,M2,M3¨ìbook1
¥Bbook1¤¤¡A¶×¤Jªº¸ê®ÆM1~M3¶¡¤£¯dªÅ¥Õ
¤p§Ì±NGBKEEª©¥Dªºµ{¦¡§ï¼g¦p¤U- Sub Ex()
- Dim Rng As Range, CopyRng As Range, I As Integer
- Set Rng = Workbooks("Book1").Sheets(1).[a65536]
- For I = 1 To 3
- With Workbooks.Open("C:\Users\tt\Desktop\·s¼W¸ê®Æ§¨\" & I & ".xls")
- ActiveSheet.Range("a4", ActiveCell.SpecialCells(xlLastCell)).Copy Rng.End(xlUp).Offset(1)
- .Close False
- End With
- Next
- End Sub
½Æ»s¥N½X ·Q½Ð±Ðªº¬O
¤@¥¹¬Ù²¤¤FActiveSheet,´N·|¥X²{"ª«¥ó¤£¤ä´©¦¹ÄݩʩΤèªk"
¬°¤°»òActiveSheet¤@©wn¼g¥X¨Ó¤~¯à°õ¦æ¡H
¶}Àɮתº®ÉÔ¡A¶}¥X¨ÓªºÀɤ£¬O³B©óActivateªºª¬ºA¶Ü¡H
´ú¸Õ¹L¦b¨S¦³°õ¦æ¶}Àɰʧ@ªº®ÉÔ¡A¬Ù²¤ActiveSheet¬O¨S¦³°ÝÃDªº»¡¡C:Q |
|