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

[µo°Ý] ½Ð±Ð¦³ÃöEXCEL ¥¨¶°°õ¦æ¿ù»~1004

[µo°Ý] ½Ð±Ð¦³ÃöEXCEL ¥¨¶°°õ¦æ¿ù»~1004

½Ð±Ð¤@¤U¡AªB¤ÍCOPY¤@­ÓEXCELÀÉ®×µ¹§Ú¡AµM«á°õ¦æªí³æ¸Ì­±¤@­Ó¡u«ö¶s¡v«á¡A¥X²{¤@­Ó¿ù»~ªº°T®§¡A¿ï¾Ü¡u°»¿ù¡v«á³sµ²¦ÜVBA¡A¬Ý¤F¤@¤U°T®§¦p¤U¡G
Private Sub CommandButton1_Click()
Application.Run "ExcDesign_RIDO_IN_R1"End Sub
½Ð°Ý³o¬O¤°»ò°ÝÃD©O¡H

¦^´_ 1# ianlcc
Private Sub CommandButton1_Click()
Application.Run "ExcDesign_RIDO_IN_R1"End Sub
§A§â¥¦­×§ï¦¨
Private Sub CommandButton1_Click()
    Application.Run "ExcDesign_RIDO_IN_R1"
End Sub
¦A¸Õ¸Õ¬Ý¡I

TOP

½Ð°Ý±z¬O¤£¬O§ï¦¨¡u  Application.Run "ExcDesign_RIDO_IN_R1"¡v«e­±ªÅ¤@®æ¶Ü¡H
§Ú°õ¦æ«áÁÙ¬O¤@¼Ë¥X²{¿ù»~ªº°T®§¡G
°õ¦æ¶¥¬q¿ù»~'1004'¡G
À³¥Îµ{¦¡©Îª«¥ó©w¸q¤Wªº¿ù»~
¬O¤£¬OÁٻݭn¦w¸Ë¤°»ò³nÅé¶Ü¡H@@

TOP

°ÝÃD¦b©óExcDesign_RIDO_IN_R1³o­Óµ{¦¡¤W
¥X¤°»ò°ÝÃD«h­n¬Ý¨ì¸Óµ{¦¡¥H¤Î¹ï·Ó§Aªº¤å¥ó¤~ª¾¹D¡C
§â¤å¥ó¶Ç¤W¨Ó§a¡A§O¥s¤j®a¤Ñ«n¦a¥_ªº²q¡I

TOP

±z¦n¡A§Ú¤w¸g§âÀɮפW¶Ç¨ìºô¸ô¤W¡A¤U¸ü¡G
http://www.FunP.Net/724243
¦A³Â·Ð¤@¤U¡AÁÂÁ¡I

TOP

¦^´_ 5# ianlcc
¹D²z«D±`³æ¯Â¡A§Aªº¼Ò²Õ¤]¬OªÅªº¡A
¦]¬°§ä¤£¨ì "ExcDesign_RIDO_IN_R1" ³o¤ä¨ç¥Ü©ÎªÌ¬Oµ{¦¡¡I

TOP

¶â¡A§ÚÂà¦^¨ìªB¤Íªº¹q¸£°õ¦æªº®É­Ô¡A¬O¥¿±`ªº¡A¤£·|¥X²{¿ù»~ªº°T®§¡ã
¥i¬O¡KªB¤Í¤£ª¾¹D­nCOPY¤°»òÀÉ®×µ¹§Ú¡K¦]¬°¥L¤]¤£ª¾¹D¨º­Ó¬O¤°»ò¡I¡I
¥L¥H«á§âEXCELµ¹§Ú´N¥i¥H¨Ï¥Î¤F¡ã
¨º§ÚÀ³¸Ó­n«ç»ò§ä¨ì¨º­Ó¡u¨ç¦¡¡v©Î¡uµ{¦¡¡v©O¡H¡H

TOP

¦^´_ 7# ianlcc
¥L¥H«á§âEXCELµ¹§Ú´N¥i¥H¨Ï¥Î¤F¡ã «üªº¬O¨Ï¥Î¥Lªº¹q¸£¶Ü¡H
¦pªGµª®×¬Oªº¸Ü¡A½Ð¦b¨º¥x¹q¸£¸Õ¹Ï§ä§ä¬Ý¡C
¨S³Jªº¥ÀÂû¬O¹å¤£¥X¤pÂûªº¡I

TOP

¦^´_ 7# ianlcc
¥ç§Y¥Ø«e¥»µ{¦¡¤º¨ÃµL
"ExcDesign_RIDO_IN_R1"»P"ExcDesign_SEQ_R1"
³o¨â°¦Ã¸¹Ï(¦Û­q¨ç¦¡)µ{¦¡¡C

TOP

¨º½Ð±Ð¤@¤U¡A§ÚªB¤Í¬O¦³¥s§Ú¥h¥L¹q¸£¸Õ¸Õ¡ã
¸Õ¤F¤@¤U¬O¥i¥H¥¿±`¨Ï¥Î
¤£¹L¡A§Ú­n«ç»ò¥h§ä¡K±z©Ò»¡ªº¡uø¹Ï(¦Û­q¨ç¦¡)µ{¦¡¡v¦b¥Lªº¹q¸£¤¤¡I¡I

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD