µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ¥»ª©ºëµØ³sµ²(±N³°Äò¼W¥[)
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[¤À¨É]
¥»ª©ºëµØ³sµ²(±N³°Äò¼W¥[)
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«e¦b½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
253
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4102 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-22
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
253
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-22
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2010-11-27 13:29
|
¥u¬Ý¸Ó§@ªÌ
[¤À¨É]
¥»ª©ºëµØ³sµ²(±N³°Äò¼W¥[)
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-9-11 11:14 ½s¿è
¤@¡B¼Ï¯Ã¤ÀªRªí
°Ý¨÷½Õ¬d¸ê®Æ²Îp
¦p¦ó±q¤£¦P¤u§@ªí§ì¨ú©Ò»ÝÄæ¦ì?
nºâ¥X¨â±ø¥ó¦P®É¦s¦b±¡ªp
¦Û°Ê¿z¿ï«á,¦p¦ó§Q¥Îvbapºâ²Å¦X¿z¿ï¤§®É¶¡¥[Á`
¦p¦ó±Nsheet2¦³®Ä¤é´Á³Ì¤jȶפJsheet1«ü©w¦ì¸m¤¤
¬Û¦PÄæ¦ìªºÈ_ªº¼Æ¶q_¥[Á`
¤G¡B¹Ïªí
¹Ïªí¨î§@->Åã¥Ü¤£¦Pªº¶¡¶Z
¹Ïªí¤¤¦p¦óÅý "ª½±ø¹Ï" »P "§é½u¹Ï" ¦P®É¦s¦b
¬¡°Ê¦¡¹Ïªí²©ö±Ð¾Ç
¤T¡B¸ê®ÆåªR
¸ê®Æ¤Á³Î
½Ð±ÐÃö©óºI¨úÀx¦s®æ¤¤ªº°ß¤@È
¥|¡B¿z¿ï
¤¡B®æ¦¡¤Æ±ø¥ó
²L½Í±ø¥ó®æ¦¡¤Æ
®æ¦¡¤Æ³]©w°ÝÃD(±Æ¥ðªí°²¤é¿ô¥Ø´£¿ô)
®æ¦¡¤Æ±ø¥óªº¶i«×¤é´Á
¤»¡BÀ³¥Î
¦p¦ó¨ú±o¤¤¤åªºª`µ«÷µ
¥ßÅé°Ñ·ÓÀ³¥Î
¤À²Õ±Æ§Ç
¤C¡Bºî¦X¾Þ§@
¤½¦¡»P°ò¥»§Þ¥©ºt½m
°Q½×¤£«½Æ²M³æ
LOOKUPºë¸Ñ
Àx¦s®æ¦Ûq®æ¦¡
¼Ó¥D¼ö©«
°Êµe¿ý»s³nÅé¤À¨É
VBAªº¼g§@§Þ¥©»P¼W¶i®Ä¯à
¤½¦¡¿é¤Jªº±`¥Î§Þ¥©(·s¤â¥²Åª)
¾Ç²ßExcel VBAªº¤@¨Ç°ò¥»·§©À
Ãö©óDDE°ÊºA³sµ²°ÝÃD
For...Next »P For Each...Next °j°éªº°ò¥»
Àx¦s®æ¦Ûq®æ¦¡
°Q½×¤£«½Æ²M³æ
¦ÛqApplicatoin¨Æ¥ó/ºÊ±±©Ò¦³¬¡¶Ã¯/°µ¦¨¼W
ÀÉ®×¾Þ§@½d¨Ò (Dir / Filesystem Object)
1
µû¤À¤H¼Æ
gong:
³ÒW¥\°ªªº¤u§@
ª÷¿ú + 3
¦¬ÂÃ
¤À¨É
¾Ç®üµL²P_¤£®¢¤U°Ý
lovetony
µoµu®ø®§
¥[¬°¦n¤Í
lovetony
·í«eÂ÷½u
UID
16949
©«¤l
2
¥DÃD
0
ºëµØ
0
¿n¤À
2
ª÷¿ú
2
ÂI¦W
0
§@·~¨t²Î
Win 7
³nÅ骩¥»
Win 7
¾\ŪÅv
10
¦b½u®É¶¡
0 ¤p®É
µù¥U®É¶¡
2014-3-19
³Ì«áµn¿ý
2014-3-19
¤p¾Ç¥Í
©«¤l
2
¥DÃD
0
ºëµØ
0
¿n¤À
2
ÂI¦W
0
§@·~¨t²Î
Win 7
³nÅ骩¥»
Win 7
¾\ŪÅv
10
µù¥U®É¶¡
2014-3-19
³Ì«áµn¿ý
2014-3-19
2
#
µoªí©ó 2014-3-19 11:07
|
¥u¬Ý¸Ó§@ªÌ
ÁÂÁ¤j¤jªº¾ã²z¡A§ä¸ê®Æ¤è«K¦h¤F¡C
TOP
ÀR«ä¦Û¦b :
¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡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¯»µ·