modify from XMLHTTP to ServerXMLHTTP for enabling proxy use

Question

@Qharr How would one modify your wonderful script from XMLHTTP to ServerXMLHTTP for enabling proxy?

REF: Google search via VBA no results if use a phone number

Have reviewed this as without finding a solution: Differences between XMLHTTP and ServerXMLHTTP

    With CreateObject("MSXML2.XMLHTTP")
    .Open "GET", urlx, False
    '.setProxy 2, "proxy.net:8080"
    '.setProxyCredentials "proxy_login", "proxy_password"
    .send
    html.body.innerHTML = StrConv(.responseBody, vbUnicode)
End With

QHarr · Accepted Answer · 2019-02-11 04:59:09Z

1

Try the following

.setProxy 2, "http=myProxyServer:8080", ""

This is using MSXML2.ServerXMLHTTP. Taken from here

Note the use of config

proxycfg -u

Also, see the link to proxycfg and how can I specify a proxy configuration using Microsoft.XMLHTTP?

If you decide to use a browser, see the following for using selenium and proxy.

Feedback from OP:

XMLHTTP.setProxy 2, "http=url or IP:port" 
XMLHTTP.setProxyCredentials "username", "password"

edited Feb 11, 2019 at 4:59

answered Jan 30, 2019 at 17:10

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Tahor Sui Juris Over a year ago

thank you. There is an issue with the following line of code which is not working with MSXML2.ServerXMLHTTP (by the way LOVE your script), please view the specific portion of your script in reference: [link]i.imgur.com/GPElqc6.png

QHarr Over a year ago

Remove that and use the .responseText direct without the strconv

Tahor Sui Juris Over a year ago

Excellent!, that resolved the run issue without adding the proxy configuration. Thank you. The remaining issue is the proxy line of code solution you shared with me above. Have reviewed the links you shared. How can I confirm the proxy is actually being applied? As your script runs but there is no indication that the proxy was actually used. Here is the line of code for the proxy: 'api.scraperapi.com?key=YOURAPIKEY&url=http://httpbin.org/ip' in relation to: 'XMLHTTP.setProxy 2, "http=myProxyServer:8080", ""' 'XMLHTTP.setProxyCredentials "proxy_login", "proxy_password"'

Tahor Sui Juris Over a year ago

QHarr Should I mark the challenge resolved, as your script runs BUT I do not think it is actually using the proxy. here is the line of code that I am trying to function: curl "http://api.scraperapi.com?key=YOURAPIKEY&url=http://httpbin.org/ip" Any suggestions greatly appreciated, thank you.

Tahor Sui Juris Over a year ago

just now saw your message. 'XMLHTTP.setProxy 2, "http=url or IP:port" 'XMLHTTP.setProxyCredentials "username", "password"

|

Collectives™ on Stack Overflow

modify from XMLHTTP to ServerXMLHTTP for enabling proxy use

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related