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

[µo°Ý] ¦p¦ó§ì¨úºô­¶­ì©l½X¡H

[µo°Ý] ¦p¦ó§ì¨úºô­¶­ì©l½X¡H

§Ú·Q±Nºô­¶(ºô§}1)µ²¦X¦Üexcel¤¤¡A¦ý¦³¤@¨BÆJ»Ý­n¨Ï¥ÎªÌ«ö¤U«ö¶s«á
¸g¹Lserver¹Bºâ§¹¡Aºô­¶(ºô§}2)¤¤show¥X¶W³sµ²¥Ñ¨Ï¥ÎªÌ¦Û¦æ¥t¦s·sÀÉ
¦]¦¹·Q§Q¥Îvbaµ{¦¡¦Û°Ê¤U¸ü¨Ã¦s¦Ü«ü©w¦ì¸m
¥Ø«e¤wª¾¥H¤Ucode¡G

Set WinHttpReq = CreateObject("Microsoft.XMLHTTP")
    'WinHttpReq.Open "GET", myURL, False, "username", "password"
    WinHttpReq.Open "GET", user_URL, False
    WinHttpReq.send
    sourcecode = WinHttpReq.responseText

¥i¥H§ì¨ú¨ì­ì©l½X¡A¤£¹L¡K
¥Ñ©óºô§}1 ©Mºô§}2 ¬O¤@¼Ò¤@¼Ëªº¡A§Ú¥u¯à§ì¨ú¨ìºô§}1 ªºsource code
¥i¬O§Ú»Ý­nªº¬O¸gserver¹Bºâ¹L«áªººô§}2 source code
·Q½Ð°Ý³o­Ó°ÝÃD¸Ó¦p¦ó¸Ñ¨M¡H

¥d¦b¦p¦ó«ö¤U«ö¶sªº°Ê§@¶Ü¡H

TOP

¦^´_ 2# rbktwi


¥d¦b  «ö¤U«ö¶s«á¡AµLªk¥¿½T§ì¨ì¸Óºô­¶ªº­ì©l½X

¦]¬°serverºÝ³B²z¦n«á¡A·|¦^¶Ç¸ê®Æµ¹user¤U¸ü

¦ýºô§}¸ò«ö¤U«ö¶s«e¬O¤@¼Ëªº¡A©Ò¥H¥Ø«e§Ú¥u§ìªº¨ì«ö¤U«ö¶s«eªº­ì©l½X

¦ý¨ä¹ê§Ú­nªº¬O«ö¤U«ö¶s«áªº­ì©l½X

¤£ª¾¹D¬O§_¦³¤èªk¥i¦æ

TOP

¥h¬Ý HTML source, §ä¨ì form ¤§¶¡ªº item, ¥Î get ©Î¬O post ªº¤è¦¡±N item/value Áýµ¹¥¦

TOP

¦^´_ 4# diolin

½Ð°Ý¤j¤j ³o¼Ë¦³¿ìªk§ì¨ì¸gserver¹Bºâ¹L«áªºdata¶Ü¡H

¥i§_´£¨Ñ½d¨Ò¡A·PÁ : )

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD