- ©«¤l
- 8
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 44
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-1-14
- ³Ì«áµn¿ý
- 2015-8-11
|
§Ú·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 |
|