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

[­ì³Ð] ¨Ï¥ÎExcel»s§@µµ·L¤æ¼Æ±Æ½Lµ{¦¡

[­ì³Ð] ¨Ï¥ÎExcel»s§@µµ·L¤æ¼Æ±Æ½Lµ{¦¡

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2015-3-5 23:11 ½s¿è

ªþ¥ó¦b22¼Ó¡A¤w§ó·s³Ì·sªO¥»/¦P®É¤]¬O [¦Û­qÀ˵ø¼Ò¦¡] ½d¨Ò

¨Ï¥ÎÀÉ®×:
1.¶}±Ò µµ·L¤æ¼Æ±Æ½Lµ{¦¡KEY.exe '¦¹KEY¤w²¾°£¤£¨Ï¥Î
2.¿ï¾Ü µµ·L¤æ¼Æ±Æ½Lµ{¦¡ Design By Hung-Chi Lin³±¶§¾äÂà´«¥[µ§¹º.xlt ¥Î¥H¶}±Ò¦¹ÀÉ

****************************************************************************
¨Ï¥ÎExcel»s§@µµ·L¤æ¼Æ±Æ½Lµ{¦¡
Ãö©óExcelª©¥»´ú¸Õ2000/202/2003/2007¤§°ÝÃD
´ú¸Õ¤F4­Óª©¥»ªºEXCEL
1.¦b2000ª© »P 2002ª©  ¨S°ÝÃD
2.¦b2003ª© »P 2007ª©  µo¥Í¸ê®Æ¿òº|°ÝÃD(¤w­×¥¿ ­«·s¶ñ¤J¿òº|)
3.­×¥¿³±¾ä¶|¤ëÂà´« ªº³¡¥÷Åýµ{¦¡¯àÂà´«³±¶§¾ä¨Ã¯à¹Bºâ³±¾ä¶|¤ë
*******************************************************************************************
ÅÞ¿è
¤j­­¥|¤Æ ¨Ï¥Î ¤j­­®c ¤z
¬y¦~¥|¤Æ ¨Ï¥Î ¬y¦~     ¤z
¬y¤ë¥|¤Æ ¨Ï¥Î ¬y¤ë     ¤z¬y¤é¬y®É ¥u±Æ½L ¤£±Æ¥|¤Æ
¬y¦~ ¥H¬y¦~·í¦~¤ä°_©R®c
¬y¤ë ¥H¬y¦~©R®c°_¤@¤ë¶¶®É°w±À¤G¤T¤ë
¬y¤é ¥H¬y¤ë©R®c°_¤@¤é¶¶®É°w±À¤G¤T¤é
¬y®É ¨Ì¦U®c¤ä ¤l®É©R®c¦b¤l;¥f®É©R®c¦b¥f

*******************************************************************************************
µ{¦¡¥\¯à
  1.±Æ½L ¤Ñ½L/¤j­­/¬y¦~/¬y¤ë/¬y®É
  2.¯¯°©ºq

»Ýª`·Nªº³¡¤À
  1.³±¾ä¸ó¦~°ÝÃD
  2.¶|¤ë¸ó¤ë°ÝÃD
  3.¤l®É¸ó¤é°ÝÃD
¿é¤Jµe­±

³o­Ó­n¾Ç¤@¤U¡A§ï¤Ñ¥i¨ì«á¨®¯¸Â\Åuºâ©R½k¤f¡C

TOP

Excel»s§@µµ·L¤æ¼Æ±Æ½Lµ{¦¡ ª©¥»§ó·s20110101

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-6-12 21:26 ½s¿è

¦p¦ó¨Ï¥ÎÀÉ®×:
1.ª½±µ¶}±ÒÀɮקY¥i
2.»Ý¶}±Ò¥¨¶°¤~¯à¨Ï¥Î
3.Àɮפº¦UºØ«OÅ@«O±K¥þ³¡¥¼Âê©w¡A·½½X¥þ³¡¤½¶}¡AÂI¿ï³]­p¼Ò¦¡Åã¥Ü¥þ³¡SHEET
****************************************************************************
¥»¦¸­×¥¿
  1.³±¾ä¸ó¦~°ÝÃD
  2.¤j­­¡B¬y¦~¡B¬y¤ë¡B¬y¤é¡B¬y®É¥[¤J¥|¤Æ»P¤å©÷µ¥¦h¶µ

ÁôÂÃ¥\¯à
»Ý¦Û¦æ¬d¸ß¬y¤é¤z¤ä«á¿é¤J¤z¤ä¡A¬y¤é¬y®É½L¤~·|·Ç½T(ÂI­º­¶¤Wªº©¯¹B¯ó¤~¯à¶i¤J¬y¤é¤z¤ä¿é¤J°Ï)

¨ä¥L§Þ¥©À³¥Î»¡©ú¡GExcel»s§@µµ·L¤æ¼Æ±Æ½Lµ{¦¡ ª©¥»§ó·s20110101

TOP

[ª©¥DºÞ²z¯d¨¥]
  • HUNGCHILIN(2011-11-3 18:18): ¥Î¹L´Nª¾¹D «Ü²Ó

³o­Ó·|«Ü¸Ô²Ó¶Ü?ÁÙ¬O¥u¬Oºâ¥X¬y¦~
XX

TOP

EXCEL¥i¥H±Æ©R½L?¯«°Ú!
·Q¤U¸ü¬Ý¬Ý
ELIOT JENG

TOP

ÆZ­È±o¬ã¨s¡A¥¿¦poobirdª©¤j«Øijªº¡A¯uªº¥i¥H¨ÓÂ\Åuºâ©R½k¤f¤F¡I

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-7-19 11:50 ½s¿è

ª©¥»§ó·s:¥i¦Û°Ê¿é¤J¬y¤é¤z¤ä

abbr_383e95aaf85a6524d67515c6266649af.rar (375.62 KB)

TOP

¦^´_ 7# HUNGCHILIN
ª©¤j¡IÁÂÁ¤À¨É¡I
¿ò¾Ñªº§ó·sª©¬OÂê½Xªº¡A¬O¬GµLªk¤@¿s¨s³º¡A±q¦Ó¾Ç²ß¡I

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-6-13 20:08 ½s¿è

³o­ÓVB±M®×±K½X¬O: 1

TOP

¦^´_ 9# HUNGCHILIN


'VBA¼Ò²ÕÁôÂáA¬OHUNGCHILIN / ªL§»¦N©Òµo®i¥X¨Óªº¤@ºØVBAµ{¦¡½X«OÅ@¤èªk
'¦¹¤èªk¤w¥Ó½Ðµo©ú±M§Q¡A»s§@¦¨¹ê«~³nÅé¼Ò²ÕÁôÂüW¯q¤u¨ã

¦n¼F®`
«Ü¦n©_«ç»òÁôÂø̭±ªºµ{¦¡½X
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD