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

EXCEL ¹Ï§ÎY¶b³]­p

EXCEL ¹Ï§ÎY¶b³]­p



¦b³oÃä¸ò«Ü¦h«e½ú¾Ç²ß¨ì«Ü¦hVBA©Mexcel¬ÛÃö¥Îªk   «D±`·PÁÂ
²{¦b¹J¨ì­Ó¤p°ÝÃD·Q½Ð±Ð¤@¤U  
excelªº¹Ï  ¦pªG¦³¨âµ§¸ê®ÆY¶b¤j¤p®t«Ü¦h   
°£¤FÂù¶bªº§@ªk¥~
¦³¥i¯à§Ë¦¨³æ¶b¤W¤U¤Á³Î   ¹³¬Oªþ¹Ï¨º¼Ëªº¼Ë¤l¶Ü
·PÁ¦U¦ì¦^µª

ÆZ§Æ±æ Excel ¯à¦³¦h¼h¦¡³æ¶bªí¥Ü¤§¹Ï¼h¡A´N¹³¬O§Ï¶¡ªº MultiCharts ¤@¼Ë¡A
¤£ª¾ Excel ¯à§_¦p¦¹ªí¥Ü¡H
·q½Ð¦U¦ì«ü±Ð¡I

TOP

EXCEL ¹Ï§ÎY¶b³]­p¨ä¹ê¬O­Ó«Ü¦nªºÄ³ÃD¡A
µ¥¤F§Ö¤@¤Ñ¤F«oµL¤H¦^À³¡A
¤£ª¾ Excel ¬O§_¯à¦p sleepycat ©Ò´£°Ý¤§¤è¦¡¨Óªí¥Ü¡H
³o¤]¬O­ÓÆZ­È±o±´°Qªº°ÝÃD¡A·q½Ð¦U¦ì¤j¤j«ü±Ð¡I

TOP

¬O§_Ãþ¦ü¤U¹Ï³o¼Ë

TOP

¦^´_ 4# kobo
±z³o¬O¦b¤@­Ó¹Ïªí¤¤Â\©ñ¤F¤@­Ó¥H¤Wªº¹Ï«¬¡A§í©Î¬O±N¤@­Ó¥H¤Wªº¹Ïªí¨Ì§ÇÅ|©ñ¦A¤@°_¡H
¦pªG¬OÄÝ©ó«eªÌ¡A±z¬O¦p¦ó°µ¨ìªº¡H
·q½Ð«ü±Ð¡I ÁÂÁ¡C

TOP

³o¬O¤T­Ó¹Ïªí°µ¦¨

TOP

¬Ý°_¨Ó¹ê¦b¬O«D±`ºë¬ü   ¥i¥H½Ð±z¤À¨É¦p¦ó¤T­Ó¹Ï¦X¨Ö§Ë¦¨¨º¼Ë¶Ü

TOP

¥»©«³Ì«á¥Ñ kobo ©ó 2012-4-11 11:13 ½s¿è

²Ä¤@¹Ï»s§@­«ÂI»¡©ú(¦]¤å¦r敍­z¤£©ö,²Ó¸`³¡¥÷¦³°ÝÃD½Ð´£¥X)
[¦]¯»¬õ¦âªº¬Wª¬¹Ïªº¸ê®Æ­È(°²³]¬°"¶q")»P¨ä¥L¸ê®Æ®t²§¤Ó¤j,
¬G°£¤F"¶q"ªºY¶b¬°²Ä¤G§¤¼Ð¶b¥~,¾l§¡¬°²Ä¤@§¤¼Ð¶b]

* ¹Ïªí¤¤¤§¦U­Ó¼Æ¦Cªºrow(¨Ó·½¸ê®ÆªºX¶b)ªº°_©l,µ²§ôªº­È¶·¬°¤@­P,¬Ý°_¨Ó¤~¤£·|¥X¿ù

1.¥ý»s§@ªÑ²¼¹Ï(K½u¹Ï)
2.Åܧó¹ÏªíY¶bªº³Ì¤j,³Ì¤p­È¦Ü¾A·í¼Æ­È
3.³°Äò¥[¤J½u©Ê¹Ï(¦p§¡½u,¤ä¼µ½uµ¥)
  3-1¦b¹Ï¤WªÅ¥Õ³B«ö¥kÁä¿ï-¨Ó·½¸ê®Æ-¼Æ¦C
  3-2¼Æ¦C(S)-·s¼W
  3-3¦WºÙ(N)-ªÅ¥Õ®æ¥k°¼ÂI¿ï©Îª½±µ¶ñ¼g
  3-4¼Æ­È(V)-ªÅ¥Õ®æ¥k°¼ÂI¿ï
  3-5Ãþ§OX¶b¼ÐÅÒ(T)-ªÅ¥Õ®æ¥k°¼ÂI¿ï(¼Æ¦r³¡¥÷»PK½u¹Ï¬Û¦P)
4.¥[¤J"¶q"ªº§@ªk(²Ä¤G§¤¼Ð¶b)
  4-1¦]¦b¹Ïªí¤W¥[¤J·s¸ê®Æ·½«á,¹w³]­È¥H²Ä¤@§¤¼Ð¶b§e²{,¦Ó"¶q"»P¨ä¥L­È®t²§¸û¤j,¬°ÁקK"¶q"ªº¬Û
     ÃöÄݩʤ£©ö½Õ¾ã,¥ý»s§@¤@¦C¼Æ­È¬Û¦P¥B¸û©ö¦b¹Ï¤W§P§Oªº¸ê®Æ,µM«á¨Ì¤èªk3¦b¹Ïªí¤W¥[¤J¸ê®Æ·½,
     ³o®É¦b¹Ïªí¤W¥i¬Ý¨ì¤@±ø¼Æ­È¬Û¦Pªº½u©Ê¹Ï.
  4-2ÂI¿ï¦¹¤@½u©Ê¹Ï«ö¥kÁä¿ï-¸ê®Æ¼Æ¦C¦¡-§¤¼Ð¶b,¥ýÅÜ«K¨ä§¤¼Ð¶b¬°²Ä¤G§¤¼Ð¶b,
  4-3¨Ì¤èªk3-4§ä¦AÅܧó¸ê®Æ¨Ó·½ªº¼Æ­È¬°"¶q"ªº³¡¥÷,
  4-4Åܧ󦹤@¹ÏªíÃþ«¬

¨ä¾l¹Ïªí§@ªk§¡»P¦¹Ãþ¦ü

¦pªG³æ¤@¹Ïªí»s§@¨S°ÝÃD,¥u­n¦U¹Ïªí¤¤¤§¦U­Ó¼Æ¦Cªºrowªº°_©l(¨Ó·½¸ê®ÆªºX¶b),µ²§ôªº­È½Õ¾ã¦¨¤@­P
(¤]´N¬O¤èªk3-4¼Æ­È(V)¤¤ªº"¼Æ¦r"³¡¥÷),§Y¥i§¹¦¨

±µ¤U¨Ó,¥i¥H¼¶¼gVBA¨Ó½Õ¾ãX¶b¤ÎY¶b,¨Ï¨ä¹Ïªí¸ê®Æ¨ã¦³¥i¥H¦V«e©Î¦V«áÆ[¬Ýªº¥\¯à

TOP

±zªºÀɮׯuªº¬Oºë¬ü¨ìÅý¤H¤Ó¨ØªA¤F
¤À¶}ªº¤@­Ó¹Ïªí§Úª¾¹D«ç»ò§Ë
ÁÙ¬O±z¨º­Ó¥u¬O¤T­Ó¹Ïªí   µM«á©ñ¦b¤@°_¥h±¼Ãä®Øªº·Pı¡H¡H

¤£¹L¦³­Ó¤p°ÝÃD¦A½Ð±Ð¤@¤U
¹Ï¤º¦³±ø««ª½ªº¦Ç½u©M¤@¨Ç¤ô¥­½u  ¨º¸Ó¤£·|¤]¬O¥Î¹Ïªí¦Û°Ê²£¥Íªº§a¡H

TOP

¥H¤U½d¨Ò,½Ð°Ñ¦Ò
test.rar (67.41 KB)

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD