Questions tagged [msxml2]
54 questions
3
votes
1 answer
MSXML2.ServerXMLHTTP clientcertificate
I'm using MSXML2.ServerXMLHTTP in JScript / VBA and want to set the client certificate path. In WinHTTP.WinHTTPRequest I could use the option '.setClientCertificate', but this seems absent in MSXML2.ServerXMLHTTP.
Is there any argument I can use for…
JasperD
- 152
- 1
- 3
- 15
3
votes
0 answers
In VBA, object MSXML2.XMLHTTP doesn't load the javascript well everytime
I'm trying to fix an old macro working with a function GetData that retrieve the whole page in the response string. (Can't give the real URL here)
Function getDataFor(tva As String) As String
' Early binding, set Tools - Reference - Microsoft…
Jonathan
- 97
- 7
3
votes
0 answers
Web Services in VBA using MSXML.ServerXMLHTTP on Mac
I have an Add-In for Excel that, at one point, I need to send and receive data via Web Services using the Microsoft XML DLLs.
The problem is that now I need to make this Add-in available for Mac.
Right from the outset I came across a problem,…
Dennys Lopes
- 49
- 1
- 4
3
votes
0 answers
MSXML2.ServerXMLHTTP HTTPS "The connection with the server was terminated abnormally "
I have the following test code in VBA in an EXCEL spreadsheet.
I am attempting to use MSXML2.ServerXMLHTTP to retrieve JSON from a remote service (the final might require storing and sending cookies to create a session to get the date so I am…
hairy_marmite
- 129
- 2
- 8
2
votes
1 answer
Where to put the sleep function in MSXML request?
I use the following function to check if a RSS url is healthy then consume it:
function testUrl(url)
testUrl=0
Set o = CreateObject("MSXML2.XMLHTTP")
on error resume next
o.open "GET", url, false
o.send
if o.Status = 200 then…
Ali Sheikhpour
- 10,475
- 5
- 41
- 82
2
votes
0 answers
Web Scraping: xmlHTTP GET request not working
I am trying to scrape flashscore.com with VBA using XMLHTTP request. It is making multiple javascript based requests to the server. One request i am interested in (as visible in the chrome developer tools) is this:
but when I send the request, it…
mobeen anwar
- 43
- 3
2
votes
2 answers
Excel vba Parse Complex XML
I need to get data from an xml file and load it to an Excel worksheet. I'm able to load the xml file and get element data in messagebox. This will written in VBA for Excel 2013
the xml file structure
Dennis Caba
- 23
- 1
- 5
1
vote
1 answer
Read XML attribute value in Inno Setup
Using How to read and write XML document node values in Inno Setup? I'm able to read values from XML file.
My file is not type XML but config (myApp.exe.config) with XML configuration:
…
pburgr
- 1,722
- 1
- 11
- 26
1
vote
0 answers
Why is XPath syntax not working in DomDocument60?
I'm trying to parse a set of FX quotes in a daily download from an ECB URL. It seems to work using DOMDocument but doesn't work when I switch to DOMDocument60. I've included both approaches in the code below. I believe I've got the XPath syntax…
Any1There
- 186
- 1
- 8
1
vote
1 answer
Create XML document using MSXML2_TLB
I want to create an xml document using MSXML2_TLB in delphi 5.
The output should look below xml, Any idea how to do this ? I am stuck on the first line with namespace, the rest of the nodes I figured out.
S Siddiqui
- 11
- 1
1
vote
1 answer
how to use MSXML2 setTimeouts to prevent timeout error?
I use the following function to check if a URL responds in a few seconds:
function testUrl(url)
Set xmlDOM = CreateObject("MSXML2.ServerXMLHTTP.6.0")
xmlDOM.Open "GET", url, False
xmlDOM.setTimeouts 1000,1000,1000,1000
…
Ali Sheikhpour
- 10,475
- 5
- 41
- 82
1
vote
0 answers
classic asp : MSXML3 dll ServerXMLHTTP
I am using below code
Set objXML = Server.CreateObject("MSXML3.ServerXMLHTTP")
objXML.Open "GET", sendstring, false
objXML.Send()
Its giving error on objXML.Send on localhost environment
I dont see any problem in this code but could not able to…
user2745580
- 123
- 7
1
vote
0 answers
Excel vba Problem in set "table variable" using msxmlhttp60
i am beginner in vba , When I run the code I get that the "tb" variable is nothing . Who can help me to fix this? if my code is incorrect how can i get the table data via msxml. i tested in IE mode and it worked fine. but it was slow
thanks a…
Lavan
- 11
- 3
1
vote
0 answers
Getting HTTP GET response and updation of existing spreadsheet data in Excel
Hi i have a Json response at a webpage that i am trying to capture update the existing spreadsheet with that data. I have referenced using the following VBScript. I am getting a blank excel and somehow the spreadsheet is not receiving the json…
prasanna kumar
- 283
- 2
- 11
1
vote
1 answer
Using getElementsByClassName with VBA
I wrote the following code in order to retrieve data from an API and hopefully get the content of a specific element. I wrote similar code that works with web pages (not API) but in this example it breaks and don't understand why.
Sub…
David912
- 378
- 1
- 2
- 11