Wicitaankan VBA wuxuu u muuqdaa inuu doorto proxy-ga ku kaydsan proxyServer:

http.setProxy 1, proxyServer, bypassList

MSXML ServerXMLHTTP, doodda koowaad waxay doorataa habka proxy-ga. Qiimayaasha la diiwaangeliyay waa 0 ee qaabeynta caadiga ah, 1 ee xiriirka tooska ah iyo 2 ee proxy si cad loo bixiyay. Cinwaan ka dib 1 ma beddelo habka tooska ah habka proxy-gacanta.

Tusaale ugu yar oo proxy-gacan ah waa:

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

Bartilmaameedka tusaalaha waa meel-bannaan. Si loo baaro proxy dadweyne, ku beddel cinwaan HTTP oo ka socda liiska proxy-yada HTTP. Doodda saddexaad waa liis dhaafis; halkan <local> waxay isticmaashaa ka-reebidda magaca maxalliga ah ee la diiwaangeliyay. Ma aha proxy labaad oo la tijaabiyo haddii kan koowaad guuldareysto. Sidaas darteed gelinta IP iyo dekedda proxy kale halkaas waxay muujinaysaa nooca qaladka ah ee dejinta.

Isticmaal joogtooyin magac leh meesha tixraacyadaada VBA ay soo bandhigaan, ama ku qeex joogtada la xiriira gudaha markaad isticmaalayso isku-xirnaan goor dambe, si habka uu u muuqdo inta lagu jiro dib-u-eegista.

Sidoo kale maskaxda ku hay nooca shayga. ServerXMLHTTP, XMLHTTP ee ku wajahan browser-ka iyo WinHttpRequest waa isku-xiryo COM oo kala duwan. Tusaale u shaqeeya mid kama caddeeyo isha qaabeynta tan kale. Marka shayga saxda ahi doorto habka proxy-gacanta, baar khalad kasta oo hadhay oo xiriir, aqoonsi ama TLS ah oo ku yaal wadadaas.

Maqaallo la xiriira