Lolu cingo lwe-VBA lubukeka lukhetha i-proxy egcinwe ku-proxyServer:

http.setProxy 1, proxyServer, bypassList

Ku-MSXML ServerXMLHTTP, i-agumenti yokuqala ikhetha imodi ye-proxy. Amanani abhaliwe yi-0 yokucushwa okuzenzakalelayo, 1 yoxhumano oluqondile kanye no-2 we-proxy enikezwe ngokusobala. Ukudlulisa ikheli ngemva kuka-1 akuguquli imodi eqondile ibe imodi ye-proxy yesandla.

Isibonelo esincane se-proxy yesandla yilesi:

Dim http As Object
Set http = CreateObject("MSXML2.ServerXMLHTTP.6.0")
http.setProxy 2, "proxy.example:8080", "<local>"
http.Open "GET", "https://example.com/", False
http.send

Iphedi yokuphela esibonelweni iyisibambi-ndawo. Ukuze uhlole i-proxy yomphakathi, shintsha ngekheli le-HTTP elivela ohwini lwe-proxy ye-HTTP. I-agumenti yesithathu uhlu lokweqa; lapha <local> lisebenzisa ukukhishwa kwegama lendawo okubhaliwe. Akulona i-proxy lesibili okufanele lizanywe uma elokuqala lihluleka. Ngakho-ke ukubeka i-IP ne-port ye-proxy enye lapho kubonisa uhlobo olungalungile lwesilungiselelo.

Sebenzisa izinguquko ezinamagama lapho izinkomba zakho ze-VBA zizidalula khona, noma chaza inguquko efanele endaweni uma usebenzisa ukuxhumana sekwedlule isikhathi, ukuze imodi ibonakale ngesikhathi sokubuyekeza.

Gcina futhi uhlobo lwento lubhekile. ServerXMLHTTP, XMLHTTP eliqondiswe kusiphequluli kanye no-WinHttpRequest yizindlela ze-COM ezihlukile. Isibonelo esisebenza kwenye asiqinisekisi umthombo wokucushwa kwesinye. Uma into efanele isikhetha imodi ye-proxy yesandla, phenya noma iyiphi iphutha elisele lokuxhumana, ukuqinisekisa noma i-TLS kuleyo ndlela.

Izihloko ezihlobene