Questions tagged [msxml2]
54 questions
0
votes
1 answer
MSXML2 - How to search specific nodes and replace its child nodes
I have this XML file
I need to search for the element by its name (for example name="DB_") and replace its children subtree with updated data.
So far I made function that returns MSXML2.IXMLDOMElement with…
Combinatix
- 1,186
- 3
- 12
- 24
0
votes
2 answers
How to download a binary file in T-SQL from a URL
I am trying to create a SQL Server stored procedure to download an unknown binary file type (usually either jpg, pdf, zip, rtf, or doc) from the specified URL.
When this is executed, I have verified that the URL is getting invoked and the file is…
Bryan Williams
- 452
- 1
- 5
- 17
0
votes
1 answer
Xpath works for MSXML2.DOMDocument, but not for MSXML2.DOMDocument.6.0
For parsing my XML documents in MS Excel VBA, I have to use MSXML2.DOMDocument.6.0.
XPath statements like the following:
Public xml_document As Object
Public xml_namespace_uri As String
...
xml_namespace_uri =…
Sunclass
- 1
- 2
0
votes
0 answers
The problem with xml parsing using MSXML2: one first node is repeated when ten different nodes should be listed
The problem mentioned in the title occurs in using selectSingleNodes. I believe it has to do with xPath of the method. I denoted the problematic lines in the code below with "<===== HERE"
In the line HERE A, I tried…
Pine Paul
- 1
- 1
0
votes
0 answers
How to use the MSXML2.XMLHTTP object outside VPN?
I have coded these few lines below. The code correctly works when I connect through a VPN but no longer works outside VPN. The returned status code is 12007 out VPN and 200 with the VPN.
For example, you can use myUrl :…
Christophe C.
- 147
- 3
- 13
0
votes
2 answers
Show image in Excel using VBA from rest is not showing any image
I am trying to insert an image from a request and it is not showing any image.
Here is my VBA code
Sub InsertPicFromURL()
Dim myUrl As String ' path of pic
Dim myPicture As Picture ' embedded pic
…
Ricardo Cerceau
- 3
- 1
- 3
0
votes
0 answers
MSXML2.ServerXMLHTTP send exits method
I have a report in access that gets an image from a url when charged, for this purpose I use MSXML2.ServerXMLHTTP to get the url.
Here is the code used:
Dim sURL As String
Dim v As Variant
v = Split(sURL, "/")(UBound(Split(sURL, "/")))
Dim obj…
adrian
- 97
- 2
- 12
0
votes
0 answers
Excel Macro not working after Updating System to Windows10 64-bit from Windows8 32-bit
I have using below code in Windows8 32-bit System and it was working fine but same code is not working in Windows10 64-bit System.
URL = "https://www.nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=" & scripID & Chr(38)…
0
votes
1 answer
Replacing values in XML node within VB6
My goal is to find and replace the values for (id, name, status) within an XML Node in VB6 using MSXML2.DOMDocument. I am working with older code but I didnt expect it to be this difficult I can pull the exact node I need from within the xml with…
Samantha Iren Martin
- 45
- 9
0
votes
1 answer
Problem with selectSingleNode on ms-access vba
I use this simple sub on access vba
Public Sub ReadXml()
' XML FILE:
'
' sometext
'
Dim n As New MSXML2.DOMDocument60
Dim n1 As MSXML2.IXMLDOMNode
Const NomeFile = "C:\file.xml"
n.async = False
…
IfThenElse
- 485
- 5
- 13
0
votes
0 answers
MSXML2.XMLHTTP times out once in a while
Trying to determine if a file exists on the server using an MSXML2.XMLHTTP request. It works most of the time but every once in a while fails with "Operation timed out". At most, there error condition kicks in once and theh it returns to working…
DrIzzy
- 1
0
votes
1 answer
MSXML2 drops Encoding?
I'm having some trouble loading an xml file into 'DOMDocument60'.
It's a plain text file saved as XML.
After the load in VBA it's missing the encoding line.
Any ideas? Many thanks in advance,
Dim MyDom As MSXML2.DOMDocument60
Set MyDom = New…
Gregory
- 149
- 2
- 5
- 13
0
votes
0 answers
VBS not sending "GET" request more times
I created small app in visual studio to control my raspberry pi but when I press button second time the request is not sent.
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim URL As String
Dim objRequest
…
Marian
- 23
- 1
- 3
0
votes
0 answers
VBA get request cURL
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…
David
- 129
- 1
- 11
0
votes
1 answer
Excel VBA Web Scraping Tables Not Responding; MSXML2.ServerXMLhttp.6.0 Method
I have built a web scraper using Excel VBA that does the following:
Reads one link at a time from a list of links in a sheet called "CIK_Links".
It Goes to the link, reads its responsetext, and if in that responsetext it finds a hyperlink whose…
rickmanalexander
- 599
- 1
- 6
- 17