µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ¤TÓÃö©óµ{¦¡ªº°ÝÃD
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
¤TÓÃö©óµ{¦¡ªº°ÝÃD
vpower
µoµu®ø®§
¥[¬°¦n¤Í
vpower
·í«eÂ÷½u
UID
383
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ª÷¿ú
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
¦b½u®É¶¡
64 ¤p®É
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
¸T¤îµo¨¥
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2011-6-10 09:30
|
¥u¬Ý¸Ó§@ªÌ
¤TÓÃö©óµ{¦¡ªº°ÝÃD
¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è
¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ
¦¬ÂÃ
¤À¨É
mark15jill
µoµu®ø®§
¥[¬°¦n¤Í
mark15jill
(ÀH·ÄÆ¿ºªº¦Ð¤ò)
·í«eÂ÷½u
[±s¥Î]¼ç¤ô¸¥
UID
4247
©«¤l
852
¥DÃD
79
ºëµØ
0
¿n¤À
918
ª÷¿ú
918
ÂI¦W
0
§@·~¨t²Î
Windows 7 , XP
³nÅ骩¥»
Office 2007, Office 2003,Office 2010,YoZo Office
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¦t©z
¦b½u®É¶¡
414 ¤p®É
µù¥U®É¶¡
2011-4-8
³Ì«áµn¿ý
2024-2-21
¡@¼ÊºÙ:
ÀH·ÄÆ¿ºªº¦Ð¤ò
¡@ÀY»Î:
[±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
©«¤l
852
¥DÃD
79
ºëµØ
0
¿n¤À
918
ÂI¦W
0
§@·~¨t²Î
Windows 7 , XP
³nÅ骩¥»
Office 2007, Office 2003,Office 2010,YoZo Office
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¦t©z
µù¥U®É¶¡
2011-4-8
³Ì«áµn¿ý
2024-2-21
2
#
µoªí©ó 2011-6-10 09:31
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ 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
µoµu®ø®§
¥[¬°¦n¤Í
vpower
·í«eÂ÷½u
UID
383
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ª÷¿ú
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
¦b½u®É¶¡
64 ¤p®É
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
¸T¤îµo¨¥
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
3
#
µoªí©ó 2011-6-10 09:36
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è
¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ
TOP
mark15jill
µoµu®ø®§
¥[¬°¦n¤Í
mark15jill
(ÀH·ÄÆ¿ºªº¦Ð¤ò)
·í«eÂ÷½u
[±s¥Î]¼ç¤ô¸¥
UID
4247
©«¤l
852
¥DÃD
79
ºëµØ
0
¿n¤À
918
ª÷¿ú
918
ÂI¦W
0
§@·~¨t²Î
Windows 7 , XP
³nÅ骩¥»
Office 2007, Office 2003,Office 2010,YoZo Office
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¦t©z
¦b½u®É¶¡
414 ¤p®É
µù¥U®É¶¡
2011-4-8
³Ì«áµn¿ý
2024-2-21
¡@¼ÊºÙ:
ÀH·ÄÆ¿ºªº¦Ð¤ò
¡@ÀY»Î:
[±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
©«¤l
852
¥DÃD
79
ºëµØ
0
¿n¤À
918
ÂI¦W
0
§@·~¨t²Î
Windows 7 , XP
³nÅ骩¥»
Office 2007, Office 2003,Office 2010,YoZo Office
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¦t©z
µù¥U®É¶¡
2011-4-8
³Ì«áµn¿ý
2024-2-21
4
#
µoªí©ó 2011-6-10 09:39
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ mark15jill ©ó 2011-6-10 09:42 ½s¿è
¦^´_
3#
vpower
Óºô¶µLªk³sµ²¡A¥i¯àì¦]¦p
¯àªº¸Ü ½Ðª½±µ¥Î ½×¾Â¤º©Òªþªº ªþ¥ó¥\¯à ¤W¶Ç
¤£µM¥Î³ü¨Ç©Ç©Çªººô¯¸¤W¶Ç¥\¯à«Ü®e©ö¥X²{°ÝÃD
TOP
vpower
µoµu®ø®§
¥[¬°¦n¤Í
vpower
·í«eÂ÷½u
UID
383
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ª÷¿ú
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
¦b½u®É¶¡
64 ¤p®É
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
¸T¤îµo¨¥
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
5
#
µoªí©ó 2011-6-10 09:50
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è
¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ
TOP
mark15jill
µoµu®ø®§
¥[¬°¦n¤Í
mark15jill
(ÀH·ÄÆ¿ºªº¦Ð¤ò)
·í«eÂ÷½u
[±s¥Î]¼ç¤ô¸¥
UID
4247
©«¤l
852
¥DÃD
79
ºëµØ
0
¿n¤À
918
ª÷¿ú
918
ÂI¦W
0
§@·~¨t²Î
Windows 7 , XP
³nÅ骩¥»
Office 2007, Office 2003,Office 2010,YoZo Office
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¦t©z
¦b½u®É¶¡
414 ¤p®É
µù¥U®É¶¡
2011-4-8
³Ì«áµn¿ý
2024-2-21
¡@¼ÊºÙ:
ÀH·ÄÆ¿ºªº¦Ð¤ò
¡@ÀY»Î:
[±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
©«¤l
852
¥DÃD
79
ºëµØ
0
¿n¤À
918
ÂI¦W
0
§@·~¨t²Î
Windows 7 , XP
³nÅ骩¥»
Office 2007, Office 2003,Office 2010,YoZo Office
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¦t©z
µù¥U®É¶¡
2011-4-8
³Ì«áµn¿ý
2024-2-21
6
#
µoªí©ó 2011-6-10 10:53
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
5#
vpower
½×¾Â¤W¶Ç¥\¯à¬O±o¥ý±NÀɮק˦¨À£ÁYÀÉ«á¤~¯à
¼Ó¥D©ÒªþªºÀÉ®× ¦³Âê±K½X ~~
³q³q¬Ý¤£¨ì «¢«¢«¢«¢«¢
¬Ý¤£¨ìµ{¦¡½X «çקï= =?
TOP
vpower
µoµu®ø®§
¥[¬°¦n¤Í
vpower
·í«eÂ÷½u
UID
383
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ª÷¿ú
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
¦b½u®É¶¡
64 ¤p®É
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
¸T¤îµo¨¥
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
7
#
µoªí©ó 2011-6-10 11:23
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è
¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ
TOP
mark15jill
µoµu®ø®§
¥[¬°¦n¤Í
mark15jill
(ÀH·ÄÆ¿ºªº¦Ð¤ò)
·í«eÂ÷½u
[±s¥Î]¼ç¤ô¸¥
UID
4247
©«¤l
852
¥DÃD
79
ºëµØ
0
¿n¤À
918
ª÷¿ú
918
ÂI¦W
0
§@·~¨t²Î
Windows 7 , XP
³nÅ骩¥»
Office 2007, Office 2003,Office 2010,YoZo Office
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¦t©z
¦b½u®É¶¡
414 ¤p®É
µù¥U®É¶¡
2011-4-8
³Ì«áµn¿ý
2024-2-21
¡@¼ÊºÙ:
ÀH·ÄÆ¿ºªº¦Ð¤ò
¡@ÀY»Î:
[±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
©«¤l
852
¥DÃD
79
ºëµØ
0
¿n¤À
918
ÂI¦W
0
§@·~¨t²Î
Windows 7 , XP
³nÅ骩¥»
Office 2007, Office 2003,Office 2010,YoZo Office
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¦t©z
µù¥U®É¶¡
2011-4-8
³Ì«áµn¿ý
2024-2-21
8
#
µoªí©ó 2011-6-10 11:28
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
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
µoµu®ø®§
¥[¬°¦n¤Í
vpower
·í«eÂ÷½u
UID
383
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ª÷¿ú
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
¦b½u®É¶¡
64 ¤p®É
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
¸T¤îµo¨¥
©«¤l
155
¥DÃD
56
ºëµØ
0
¿n¤À
242
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
±M·~ª©2002
¾\ŪÅv
0
µù¥U®É¶¡
2010-5-29
³Ì«áµn¿ý
2011-7-18
9
#
µoªí©ó 2011-6-10 11:48
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ vpower ©ó 2011-6-29 16:54 ½s¿è
¼È¥ý¤£¸Ñ¨M¤F,½Ð²¾°£,ÁÂ
TOP
ÀR«ä¦Û¦b :
¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·