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

¤T­ÓÃö©óµ{¦¡ªº°ÝÃD

¤T­ÓÃö©óµ{¦¡ªº°ÝÃD

¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è

¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ

¥»©«³Ì«á¥Ñ mark15jill ©ó 2011-6-10 09:34 ½s¿è

¦^´_ 1# vpower


    ¥i§_½Ð¼Ó¥D¶Ç­ÓÀÉ®× ³o¼Ë¤ñ¸û¦n¤F¸Ñ©O
   ¦]¬°
1. ¶}±Ò«ü©wEXCELÀÉ®× ¬O ¦P¸ê®Æ§¨? ÁÙ¬O ¤£¦P¸ê®Æ§¨???
¦P¸ê®Æ§¨ ¦³¦P¸ê®Æ§¨¶}±Ò¤èªk
fs = Dir(ThisWorkbook.Path & "\*.xls")
¤£¦P¸ê®Æ§¨ «hÁÙ­n¬Ý¬O¦b­þ­Ó¸ô®| ÂǦ¹«ü©w¸ô®|¶}±Ò


2.±N¦WºÙ:³q°T¿ýªºEXCEL
C2Àx¦s®æ=INT(YEAR($G2))ªº­È¶K¨ì¦WºÙ:¬P®yªºEXCELªºD4
C2Àx¦s®æ=INT(MONTH($G2))ªº­È¶K¨ì¦WºÙ:¬P®yªºEXCELªºD5
C2Àx¦s®æ=INT(DAY($G2))ªº­È¶K¨ì¦WºÙ:¬P®yªºEXCELªºD6
C2Àx¦s®æªº­È¶K¨ì¦WºÙ:¬P®yªºEXCELªºD7
³Ì²× §AC2Àx¦s®æªº¸ê®Æ¬O¤°»ò??? D4? D5? D6?

TOP

¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è

¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ

TOP

¥»©«³Ì«á¥Ñ mark15jill ©ó 2011-6-10 09:42 ½s¿è

¦^´_ 3# vpower


    ­Óºô­¶µLªk³sµ²¡A¥i¯à­ì¦]¦p
¯àªº¸Ü ½Ðª½±µ¥Î ½×¾Â¤º©Òªþªº ªþ¥ó¥\¯à ¤W¶Ç
¤£µM¥Î³ü¨Ç©Ç©Çªººô¯¸¤W¶Ç¥\¯à«Ü®e©ö¥X²{°ÝÃD

TOP

¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è

¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ

TOP

¦^´_ 5# vpower


    ½×¾Â¤W¶Ç¥\¯à¬O±o¥ý±NÀɮק˦¨À£ÁYÀÉ«á¤~¯à
¼Ó¥D©ÒªþªºÀÉ®× ¦³Âê±K½X ~~
³q³q¬Ý¤£¨ì «¢«¢«¢«¢«¢
¬Ý¤£¨ìµ{¦¡½X «ç­×§ï= =?

TOP

¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è

¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ

TOP

¦^´_ 7# vpower


    = =½T©w¥u¦³¸Ó°Ï°ì¤WÂê¶Ü???
»¡¯uªº §Ú¤£·|¸Ñ³oºØªF¦è
L3  D4 D5 D6 D7 ³£¤WÂê
¨ä¥LÀx¦s®æ³sÂI³£µLªkÂI= =!!"
¦ü¥G¦³³Q¾B½ª

TOP

¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è

¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD