ªð¦^¦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

¦^´_ 12# Hsieh
Good Idea!

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-7-29 00:14 ½s¿è

¦^´_ 10# ianlcc

VBE½s¿è¾¹¤¤ªº±M®×Á`ºÞ
ÂI¿ï¨C­Ó±M®×¤¤ªº¼Ò²Õ¬d¬Ý¥kÃäµøµ¡ªºµ{¦¡¡A¬O§_¦³¦¹¥¨¶°

³Ì§Ö³tªº¤èªk«K¬O§Q¥ÎF8³v¦æµ{§Ç¡A·í°õ¦æ§¹
Application.Run "ExcDesign_RIDO_IN_R1"
³o¤@¦æ¥H«á¡A´N·|¸õ¨ìExcDesign_RIDO_IN_R1ªºµ{§Ç¤¤

    play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

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

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

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

¶â¡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

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD