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

§ä¤£¨ì¥¨¶°

§ä¤£¨ì¥¨¶°

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-9-26 15:20 ½s¿è

½Ð°ÝGBKEE
·í§Ú°õ¦æªü¦¿©Ò¦³³øªí¤¤ªº"¶×¤J¸ê®Æ"Áä®É·|¥X²{
§ä¤£¨ì¥¨¶°   
"¸ê®Æ·J¾ã-2.xls!Sheet1.CommandButton7_Click"
³Â·Ð±z¨ó§U¸Ñµª~~ÁÂÁÂ
¥t¥~§Úªº«H²{¦b³£MAIL¤£¹L¥h

ªü¦¿©Ò¦³³øªí.zip (37.28 KB)

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

TOP

©êºp~~¥H¬°¤w¸g¤W¶Ç¤F

¸ê®Æ·J¾ã-2.zip (495.08 KB)

TOP

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

TOP

±N"-"§R°£«á°õ¦æÅܦ¨¥X²{
¶W¥X¯Á¤Þ°}¦C½d³ò

TOP

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

TOP

§ó§ï«áÁÙ¬O¤@¼Ë­C~~
¶W¥X¯Á¤Þ°}¦C½d³ò
Run "¸ê®Æ·J¾ã2.xls!Sheet1.CommandButton7_Click"¡ö¡ö°ÝÃD©Ò¦b

TOP

¦^´_ 7# lone_tiger0303


    ½Ð½T»{¸ê®Æ·J¾ã2.xls¤w¸g¶}±Ò
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

°õ¦æ®É   ¸ê®Æ·J¾ã2.xls   ¬O¦b¶}±Òª¬ºA

Sub ¶×¤J¸ê®Æ()
Application.Calculation = xlCalculationManual '¤â°Ê­pºâ
Workbooks.Open Filename:="C:\Documents and Settings\k1489.KT_DOMAIN\®à­±\§õÂí¦¿\¨Ó·½¸ê®Æ\¸ê®Æ·J¾ã2.xls"  '¶}ÀÉ
Run "¸ê®Æ·J¾ã2.xls!Sheet1.CommandButton7_Click"
Run "¸ê®Æ·J¾ã2.xls!Sheet2.CommandButton11_Click"
Run "¸ê®Æ·J¾ã2.xls!Sheet3.CommandButton5_Click"
ActiveWorkbook.PrecisionAsDisplayed = False
ActiveSheet.Calculate
End Sub

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

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD