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

[µo°Ý] debug½Ð±Ð

[µo°Ý] debug½Ð±Ð

½Ð±Ð¦U¦ì¤j¤j¸Ó«ç»òdebug
°Ñ¦Ò¤F¯¸¤W»P¨¦ºq¤j¯«ªº¸ê®Æ¡A
¨Ï¥ÎMSXML2.XMLHTTP¼g¤Fªþ¥óªºVBAŪ¨úµý¥æ©Ò­ÓªÑ¤é¦¨¥æ¸ê°T¡A
§ì«e´X¤äªÑ²¼®É³£¥¿±`¹B§@¡A¦ý©¹©¹°õ¦æ¨ì¤@¥b¡A´N¥X²{µL¦^À³ª¬ºA ¡A
Ãö±¼EXCEL®É·|¬Ý¨ì·í¦bmsxml2.xmlhttp open URL«áªºsend¡A
µ{¦¡¦pªþ¥ó ¤W¥«µý¨÷¤U¸ü.rar (67.61 KB)
³o­Ó³s°²¤w¸g´ú¸Õ«Ü¦h¤è¦¡¡AÁÙ¬O³£·|·í¦í¡A©Ò¥H¤W¨Ó½Ð±Ð¤@¤U¡A
¸Ó«ç»òdebug¡H©Î¬O¸Ó«ç»ò¼g¤~¤£·|¤@ª½·í¦í¡H

²×©ó§ä¨ìµª®×¤F¡A¦Û¤v¨Ó¦^µª¤F
msxml2.xmlhttp­Y¿ï¾Üoepn°Ñ¼Æ¬°¦P¨B¡A«h¦bsend«á·|µ¥«Ý¦øªA¾¹¦^À³¡A
­YµL¦^À³¡Aµ{¦¡´N·|¤@ª½¦bsend«áµ¥«Ýªºª¬ºA
¸Ñ¨M¤è¦¡¡G
1. §ï¥Îmsxml2.serverxmlhttp¡A³]©wsettimeouts¡A¦A¶i¦ætimeout®Éªº³B²z
2. µ{¦¡§ï¦¨«D¦P¨Bmsxml2.xmlhttp.open "post", URL, True¡A¦A©ó«á­±§PÂ_ºô­¶¬O§_load§¹¦¨(readystate=4 & satus=200)

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD