.setrequestheader

Hello all, I'm trying to import some data for a fund listed on the Luxembourg SE. When I go to the site, I can insert the ISIN code, LU1883863935, in the search field and from there I can read the exchange symbol, 294814. As I'm trying to get the data into Excel, I can see when I use Inspect...

I found this bit of code and would like to use it with some changes, currently it is not working for me, possible because it is set for FIREFOX and not IE. I am having trouble changing this as I am limited in VBA This might be the issue Original link to code...

Sub BETWEF() Sheets("BetEX").Select Dim httpReq As WinHttp.WinHttpRequest Dim HTMLdoc As HTMLDocument Dim para As HTMLParaElement Dim tRows As IHTMLElementCollection Dim tRow As HTMLTableRow Dim URLs As Range, URL As Range Dim destSheet As Worksheet...

Hello, I have a problem with the MSXML2.XMLHTTP object in VBA. I need to send a message in json but the auth token has double quotes in it. So in order for those double quotes to arrive in the message a backslash is used. Now by parsing the xml to Json the xmlhttp object adds an extra...

What is the cause of this error? run-time error '-2147012894 (80072ee2)': the operationg timed out With httpReq .Open "GET", matchURL, False .setRequestHeader "Host", "www.xxx.com" .setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; WOW64...

I have the following JSON request sample code from an API service provider HTTP Method: POST URL: /services/shipper/orders POST /services/shipper/orders HTTP/1.1 Content-Type: application/json User-Agent: Mozilla 5.0 Host: api.epackcne.com Date: Tue, 06 Jan 2018 21:20:27 GMT Token...