Wannan kiran VBA yana kama da yana zaɓar wakilin da aka ajiye a cikin proxyServer:

http.setProxy 1, proxyServer, bypassList

Ga MSXML ServerXMLHTTP, hujja ta farko tana zaɓar yanayin wakili. Ƙididdigar da aka rubuta su ne 0 don saitin tsoho, 1 don haɗin kai tsaye da 2 don wakilin da aka bayar a fili. Ba da adireshi bayan 1 ba ya mai da yanayin kai tsaye zuwa yanayin wakili na hannu.

Ƙaramin misali na wakilin hannu shi ne:

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

Ƙarshen misalin wuri ne na riƙe. Don gwajin wakilin jama'a, maye gurbinsa da adireshin HTTP daga jerin wakilan HTTP. Hujja ta uku jerin tsallakewa ce; a nan <local> yana amfani da keɓancewar sunan gida da aka rubuta. Ba wakili na biyu ba ne da za a gwada idan na farko ya kasa. Don haka sanya IP da tashar wani wakili a can yana nuna nau'in saitin da bai dace ba.

Yi amfani da ma'auni masu suna inda nassosin VBA ɗinka suka bayyana su, ko ayyana ma'aunin da ya dace a gida yayin amfani da jinkirin ɗaure, domin yanayin ya kasance a bayyane yayin bita.

Ka kuma lura da nau'in abu. ServerXMLHTTP, XMLHTTP da aka karkata ga mai bincike da WinHttpRequest mu'amaloli ne na COM daban-daban. Misali mai aiki ga ɗaya ba ya tabbatar da tushen saitin ɗayan. Da zarar abin da ya dace ya zaɓi yanayin wakili na hannu, bincika duk wani ragowar kuskuren haɗi, tabbatarwa ko TLS a wannan hanya.

Labarai masu alaƙa