µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
¶i¶¥À³¥Î±M°Ï
» Excel VBA ¼W¯q¶°(Excel¦¨«~)½d¨Ò:¯}¸Ñ¤u§@ªí«OÅ@
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[ì³Ð]
Excel VBA ¼W¯q¶°(Excel¦¨«~)½d¨Ò:¯}¸Ñ¤u§@ªí«OÅ@
HUNGCHILIN
µoµu®ø®§
¥[¬°¦n¤Í
HUNGCHILIN
(ªü¦N)
·í«eÂ÷½u
¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
UID
27
©«¤l
647
¥DÃD
190
ºëµØ
24
¿n¤À
1037
ª÷¿ú
1037
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
Office 2010 ; OOO3.0 ; Google
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¦Ë«n
¦b½u®É¶¡
783 ¤p®É
µù¥U®É¶¡
2010-5-2
³Ì«áµn¿ý
2022-6-24
¡@¼ÊºÙ:
ªü¦N
¡@ÀY»Î:
¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
ª©¥D
©«¤l
647
¥DÃD
190
ºëµØ
24
¿n¤À
1037
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
Office 2010 ; OOO3.0 ; Google
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¦Ë«n
µù¥U®É¶¡
2010-5-2
³Ì«áµn¿ý
2022-6-24
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2010-5-2 18:25
|
Åã¥Ü¥þ³¡©«¤l
[ì³Ð]
Excel VBA ¼W¯q¶°(Excel¦¨«~)½d¨Ò:¯}¸Ñ¤u§@ªí«OÅ@
Excel
,
VBA
,
¼W¯q¶°
¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-1-4 23:27 ½s¿è
«OÅ@«O±KCµ¥¤u¨ã
Excel VBA ¼W¯q¶°(Excel¦¨«~)½d¨Ò:¯}¸Ñ¤u§@ªí«OÅ@
¦@¥Î¬¡¶Ã¯¥[±K/VBA¥[¸ÑÂê¾¹¥i¯}¸Ñ/¯}¸Ñ«áTHISWORKBOOK SHEETÁôÂÃ
P.S.§Þ¥© ¦@¥Î¬¡¶Ã¯¥[±K ¤§ b.ÁôÂÃÀɮ׮榡«¬ºA
³oÓ¼W¯q¶°¥Dnªº¥\¯à¬°: ¦p¦ó¯}¸ÑEXCEL¤u§@ªí«O护
¨äºc«ä¨Ó·½¬°¤U:
http://club.excelhome.net/thread-506838-1-1.html
³oÓÀɮפº®e¬O¥Ø«e
"¤u§@ªí«OÅ@"¯}¸Ñ³t«×³Ì§Öªºµ{¦¡
¾A¥Î½d³ò:EXCEL 2002~EXCEL 2007ª©
2010ª©©|¥¼´ú¸Õ
A1 .rar
(24.12 KB)
¤U¸ü¦¸¼Æ: 360
2010-5-2 18:29
¼Ó¥D¼ö©«
EXCEL«OÅ@«O±K§Þ¥©
¨Ï¥ÎExcel»s§@µµ·L¤æ¼Æ±Æ½Lµ{¦¡
ÁôÂÃÄæ¦C¤]¬O¤@ªù§Þ¥©¡@¨S¾Ç·|n³Z§O»¡·|Áô
Ãö©óVB6(or VSTO)»s§@Excel DLL¬ÛÃö§Þ¥©
¸T¤î¨Ï¥ÎªÌ¨Ï¥ÎEXCEL VBE½s¿è¾¹
¦p¦ó¨Ï¥Î¦X¨ÖÀx¦s®æÁôÂøê®Æ§@¸ê®Æ¨¾Å@
²©öª©ªº¥é VBA±M®×¥[¸ÑÂê¾¹¼W¯q¶°
¥Î¨ä¥L¤èªk«OÅ@¤u§@ªí
¦Û°Ê¦w¸Ë(¤£ªþ»¡©ú)Excel¨Ï¥ÎÂê¼W¯q¶°
VBA¦C¥X¤u§@ªí¦WºÙ®É¼Ò²ÕÅܦ¨¤u§@ªí¥BÅã¥Ü«D
¦¬ÂÃ
¤À¨É
Hung-Chi Lin/ªL§»¦N
HUNGCHILIN/ªL§»¦NªºOFFICE±MÄæ
HUNGCHILIN
µoµu®ø®§
¥[¬°¦n¤Í
HUNGCHILIN
(ªü¦N)
·í«eÂ÷½u
¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
UID
27
©«¤l
647
¥DÃD
190
ºëµØ
24
¿n¤À
1037
ª÷¿ú
1037
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
Office 2010 ; OOO3.0 ; Google
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¦Ë«n
¦b½u®É¶¡
783 ¤p®É
µù¥U®É¶¡
2010-5-2
³Ì«áµn¿ý
2022-6-24
¡@¼ÊºÙ:
ªü¦N
¡@ÀY»Î:
¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
ª©¥D
©«¤l
647
¥DÃD
190
ºëµØ
24
¿n¤À
1037
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
Office 2010 ; OOO3.0 ; Google
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¦Ë«n
µù¥U®É¶¡
2010-5-2
³Ì«áµn¿ý
2022-6-24
2
#
µoªí©ó 2010-5-18 22:10
|
Åã¥Ü¥þ³¡©«¤l
¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2010-5-18 22:22 ½s¿è
¦^ÂÐ
http://forum.twbts.com/viewthread.php?tid=247&extra=page%3D1
°w¹ï³o«h¨ä¹êÁÙ¬O¦³¨î»P¯µ³Zªº
§Ú¤w¥t¶K±Ð¾Ç»Pµo¤å
[ì³Ð] Excel VBA ¼W¯q¶°(Excel¦¨«~)½d¨Ò:¯}¸Ñ¤u§@ªí«OÅ@- ¨î»P¯µ³Z»¡©ú
Hung-Chi Lin/ªL§»¦N
HUNGCHILIN/ªL§»¦NªºOFFICE±MÄæ
TOP
HUNGCHILIN
µoµu®ø®§
¥[¬°¦n¤Í
HUNGCHILIN
(ªü¦N)
·í«eÂ÷½u
¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
UID
27
©«¤l
647
¥DÃD
190
ºëµØ
24
¿n¤À
1037
ª÷¿ú
1037
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
Office 2010 ; OOO3.0 ; Google
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¦Ë«n
¦b½u®É¶¡
783 ¤p®É
µù¥U®É¶¡
2010-5-2
³Ì«áµn¿ý
2022-6-24
¡@¼ÊºÙ:
ªü¦N
¡@ÀY»Î:
¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
ª©¥D
©«¤l
647
¥DÃD
190
ºëµØ
24
¿n¤À
1037
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
Office 2010 ; OOO3.0 ; Google
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¦Ë«n
µù¥U®É¶¡
2010-5-2
³Ì«áµn¿ý
2022-6-24
3
#
µoªí©ó 2011-11-19 12:14
|
Åã¥Ü¥þ³¡©«¤l
¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-11-19 12:52 ½s¿è
³o¸Ì¦³¤@½gì²z»P¥\¯à«D±`¹p¦P¡A¨Ã§@¦¨DLLÀɪº§å¶q¸Ñ±K¡A§Ú·QÀ³¸Ó¦³²§¦±¦P¥\¤§§®
http://www.officefans.net/cdb/vi ... 5437&highlight=
³o¤@½gºô¤Wªººc«ä¨Ó·½¬°¤U:
http://www.officefans.net/cdb/vi ... &extra=page%3D6
§Ú·Q¦pªG¥L¦³»¡©úºc«ä¨Ó·½À³¸Ó·|§ó¦n
Hung-Chi Lin/ªL§»¦N
HUNGCHILIN/ªL§»¦NªºOFFICE±MÄæ
TOP
HUNGCHILIN
µoµu®ø®§
¥[¬°¦n¤Í
HUNGCHILIN
(ªü¦N)
·í«eÂ÷½u
¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
UID
27
©«¤l
647
¥DÃD
190
ºëµØ
24
¿n¤À
1037
ª÷¿ú
1037
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
Office 2010 ; OOO3.0 ; Google
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¦Ë«n
¦b½u®É¶¡
783 ¤p®É
µù¥U®É¶¡
2010-5-2
³Ì«áµn¿ý
2022-6-24
¡@¼ÊºÙ:
ªü¦N
¡@ÀY»Î:
¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
ª©¥D
©«¤l
647
¥DÃD
190
ºëµØ
24
¿n¤À
1037
ÂI¦W
0
§@·~¨t²Î
windows7
³nÅ骩¥»
Office 2010 ; OOO3.0 ; Google
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¦Ë«n
µù¥U®É¶¡
2010-5-2
³Ì«áµn¿ý
2022-6-24
4
#
µoªí©ó 2011-11-20 12:09
|
Åã¥Ü¥þ³¡©«¤l
¤Wz¬OÂÂì²z
·sì²z¦p¤U:²Ä¤T©«
http://forum.twbts.com/thread-5073-1-2.html
Hung-Chi Lin/ªL§»¦N
HUNGCHILIN/ªL§»¦NªºOFFICE±MÄæ
TOP
ÀR«ä¦Û¦b :
n¥Î¤ß¡A¤£n¾Þ¤ß¡B·Ð¤ß¡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¯»µ·