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

[µo°Ý] §Q¥ÎEXCEL©î¸Ñ¦a§}

[µo°Ý] §Q¥ÎEXCEL©î¸Ñ¦a§}

¦]¤u§@»Ý­n ¦bª©¤W§ä¨ì¤Fª©¥DHsieh¼gªº¤À¸Ñ¦a§}ªºEXCELÀÉ®×
[url=http://forum.twbts.com/viewthread.php?tid=6290&highlight=%A6a%A7%7D]
¤½¥q¨C¤Ñ»Ý­n¦C¦L«D±`¦h³f¹B¤½¥qªº¦«¹B³æ
§Æ±æ¯à°÷ÂÇ¥ÑEXCELªº¤½¦¡³W«h¨Ó¸`¬Ù¤H¤u¥´³æªº®É¶¡&ÁקK¤H¤u°¸º¸ªº¿ù»~

§Ú«ö·Óª©¥DHsiehªºÀÉ®× ­«·s¼g¤F©w¸q&¤½¦¡
¦¨¥\ªº§â"¸ô¦W"¸ò"¬q"¤À¸Ñ¥X¨Ó¤F
¦ýÁÙ¬O¦³³\¦h¦a§}µLªk¦¨¥\¤À¸Ñ(¤×¨ä§ø¡B¨½ªº³¡¤À)
¦Û¤v¸ÕµÛ­×§ï¨ä¥L©w¸q©M¤½¦¡³£ÁÙ¬OµLªk¦¨¥\ªº±N¦a§}§¹¾ãªº¤À³Î¥X¨Ó

¦]§Ú¨Ã¨S¦³¾Ç²ß¹LOFFICEªºÀ³¥Î...¥Ø«e·|¥Îªº¤½¦¡©Î§Þ¥©³£¬O¦b¹J¨ì°ÝÃDªº®É­Ô¦bºô¸ô¤WºCºC·j´M¸Ñ¨M¿ìªk
¦Û¤v¤@Ãä°µ¤@Ãä¾Ç²ß ¦³«Ü¦h¬O§Ú¤£À´ªº
½Ð¦U¦ì°ª¤â«ü¾É ¯à°÷§â¦a§}§ó§¹¾ãªº¤À³Î¥X¨Ó ÁÂÁÂ!!
¦a§}¤À¸Ñ°ÝÃD.rar (20.7 KB)

§Ú°O±o¨½©M¾FÀ³¸Ó±Æ¦b¸ôªº«e­±¤~¹ï§a????
jeason

TOP

¦^´_ 2# brabus

³f¹B¤½¥qªº¦«¹B³æ ­«ÂI¦b ¶l»¼°Ï¸¹ + ¦a§}¦X²z

§A¥i¥H°Ñ¦Ò  http://aney22.pixnet.net/blog/post/46841794

¥Î³o¨Çºô¯¸ °t¦X vba

Set WinHttpReq = CreateObject("Microsoft.XMLHTTP")
WinHttpReq.Open "GET       
WinHttpReq.send

§ì¨úÅçÃҫ᪺¸ê®Æ ¡A½T»{¸ê®Æ¥¿½T«á¡C

¤§«áªº±Æª©¦C¦L¡A§O²z¦v°t³æªº ¿¤¥« ¶mÂí¥«°Ï ³o¨Ç­­¨î§Y¥i

§ä­Ó°®²bÂIªº¦ì¸m¡Aª½±µ¥´¦L

±Æª©ªº¤èªk¥i¥H°Ñ¦Ò¡G

http://aney22.pixnet.net/blog/post/45709522
http://aney22.pixnet.net/blog/post/45694645        


§Ú¤â¤W¦³¥|¤­¦Ê­Ó«È¤á¦a§}¡A³B²z¹L¡A§¹¥þµLªk100%«OÃÒ¯à°÷¦X²z¸ÑªR¡A³Ì«á§Ú§¹¥þ¤£©î¡A¤£²z¦v°t³æ¤Wªº¦r¡A¤@¤Á´N²³æ¤F
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

TOP

¦^´_ 1# ciara76190

¤½¦¡¦³©Ò­­¨î¡A
¤@¡B¶¶§Ç¦p¥k:   ¬Ù ,¿¤ ,¥« ,¶m ,Âí ,°Ï ,¨½ ,§ø ,¾F ,¸ô ,¹D ,µó ,¼d ,¬q ,«Ñ ,§Ë ,¸¹ ,¼Ó ,«Ç
¤G¡B¤´¦³©_©Ç¦a¦W¥i¯àµLªk§¹¥þ¸ÑªR

¤½¦¡·§©À
§ä¥X«e¦r¦ê¤§«á¬O§_¦³²Å¦X¸ÓÄæ KEY WORDªº¦ì¸m¡A­Y¦³¨ú¥X

¦WºÙ¤½¦¡
°_©l¦ì¸m =MAX(FIND($B3:B3,$A3)+LEN($B3:B3))

C3 {=MID($A3,°_©l¦ì¸m,IFERROR(FIND(C$1,$A3,°_©l¦ì¸m+C$2-1)-°_©l¦ì¸m+1,0)) }

½d¨ÒÀÉ®×
¦a§}¤À¸Ñ°ÝÃD.rar (66.06 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# eigen


ÁÂÁ±zµ¹ªº«Øij §Ú¦³¦Ò¼{¹L³o­Ó¤èªk
¦ý§Ú­Ì¥Ø«e°t¦Xªº³o¶¡³f¹B
¦pªG¨S«ö·Ó¥L­Ì¦«¹B³æªº®æ¦¡¥h¶ñ¼gªº¸Ü¥L­Ì«Ü®e©ö§â¦a§}§Ë¿ù....

±Æª©ªº³¡¤À§Ú¤w¸g¦Û¦æ½Õ¾ã¤]³]©w¦n¤F
°Ñ¦Ò¤F±z´£¨Ñªº¤è¦¡
®Mª©¦C¦Lªº±Ð¾Ç«Ü´Î! §Ú¨S¦³·Q¹Lµo²¼¤]¥i¥H¥Î³o¼Ëªº¤è¦¡¦C¦L
¦Ü©ó¥¨¶°¸òVBAªº³¡¤À §ÚÁٻݭn¦A§V¤O¾Ç²ß«ç»òÀ³¥Î

TOP

¦^´_  eigen
ÁÂÁ±zµ¹ªº«Øij §Ú¦³¦Ò¼{¹L³o­Ó¤èªk
¦ý§Ú­Ì¥Ø«e°t¦Xªº³o¶¡³f¹B
¦pªG¨S«ö·Ó¥L­Ì¦«¹B³æªº ...
ciara76190 µoªí©ó 2017-6-8 13:40


§A¥i¥H¨è·N±N¥L­Ì·|§Ë¿ùªº¦a¤è¡A¨è·N¥´¦L »\±¼

°ò¥»¤W¹q¸£¦C¦L¡A«ç¼Ë¤]¤ñ¤â¼g®¥¾ã¡A³o¼Ë¦A¬Ý¿ù¥i¥H¥h¦º¤@¦º¤F~~
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD