ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

§ä¤£¨ì¥¨¶°

¦^´_ 1# lone_tiger0303
½Ðªþ¤W  "¸ê®Æ·J¾ã-2.xls"  ¥H«K°»¿ù

TOP

¦^´_ 3# lone_tiger0303
¸ê®Æ·J¾ã-2.xls  ³o - ªºÃö«Y ,¥t¦sÀɦW¤£­n¦³³o²Å¸¹§a

TOP

¦^´_ 5# lone_tiger0303
¸ê®Æ·J¾ã-2.xls-> §ï¥t¦sÀɦW:  ¸ê®Æ·J¾ã2.xls  ,µ{¦¡¤¤¤]­n¤@¨Ö§ó§ï§r .

TOP

¦^´_ 9# lone_tiger0303
½ÐÀˬd  ¸ê®Æ·J¾ã2.xls ¤¤ªºSheets
Run "¸ê®Æ·J¾ã2.xls!Sheet1.CommandButton7_Click"
Run "¸ê®Æ·J¾ã2.xls!Sheet2.CommandButton11_Click"
Run "¸ê®Æ·J¾ã2.xls!Sheet3.CommandButton5_Click"

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-9-29 13:00 ½s¿è

¦^´_ 11# lone_tiger0303
¦³¿ù»~®É «öF8³v¦æ¬d¬Ý§ä¥X¿ù»~ÂI¬Ý¬Ý
¸ê®Æ·J¾ã-2.xls-> §ï¥t¦sÀɦW:  ¸ê®Æ·J¾ã2.xls  ,µ{¦¡¤¤¤]­n¤@¨Ö§ó§ï§r    §A¨S§ï¥¿
³o¬O§A­è¶Ç¤WÀɮפ¤ªºµ{¦¡½X
Workbooks("¸ê®Æ·J¾ã-2.xls").Worksheets("§Þ®v«O¥À").Range("d4:k30000").Value = ""
Workbooks("¸ê®Æ·J¾ã-2.xls").Worksheets("§Þ®v«O¥À").Range("n4:t30000").Value = ""
Workbooks("¸ê®Æ·J¾ã-2.xls").Worksheets("§Þ®v«O¥À").Range("be4:bo30000").Value = ""

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD