c_c_lai

¦^´_ 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

c_c_lai

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

c_c_lai

¦^´_ 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

c_c_lai

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

c_c_lai

¦^´_ 10# ianlcc
¤@¡B ¦b¥L¨º¥x¹q¸£¤W¡AÀH«K¥t¥~«Ø¥ß¤@­Ó¥Ø¿ý (Sub Directory) (¨Ò¦p¦b D ¼Ñ®Ú¥Ø¿ý¤W«Ø¥ß¤@­Ó¥s°µ Test ªº¥Ø¿ý¡G D:\Test\)¡A
         ±µµÛ§A§â¥Lªº¨º°¦ Excel Àɽƻs¨ì D:\Test\ ¤º¡AµM«á¦b Test ¥Ø¿ý¤U¥h°õ¦æ½Æ»s¹L¨Óªº¨º°¦ Excel ÀÉ¡A ¬Ý¬Ý¥¦¬O§_¯à°õ¦æ¡C
¤G¡B ¦pªG¥¦¯à¦b D:\Test\ ¤º°õ¦æ¡A«h½Ð§A¨ì VB µ{¦¡¸Ì¬Ý¬Ý¥¦ªº¨C°¦µ{¦¡½X¦³§_¯Ê¤Öªº¨º¨â°¦µ{¦¡¡A¸ÕµÛ¬Ý¬Ý¼Ò²Õ¸Ì¬O§_¬O
         ªÅ¥Õªº¡H
¤T¡B ¦pªG ¤@ ¬OOK¡B¤G ¤£¦¨¥ß¡A «h¥i¯à¬O¦w¸Ë¦³¨ä¥¦¼Ò²Õµ{¦¡¦b¥L¨º³¡¹q¸£¤W¡A¨º§A´N¥²¶·¥h¤F¸Ñ¤§«eªº¦w¸Ë±¡§Î¤F¡C

c_c_lai

¦^´_ 12# Hsieh
Good Idea!