Questions tagged [msxml2]
54 questions
0
votes
1 answer
how to prevent cached response from MSXML2.XMLHTTP, vbscript
I'm writing a wscript with vbscript in Windows 7.
The script needs to grab a file from an open ftp server, so I must use MSXML2.XMLHTTP object
The file I am grabbing is being cached in a sub folder…
Steve Wasiura
- 768
- 1
- 8
- 19
0
votes
1 answer
obj.Attributes(0) returns "ID", obj.getAttribute("ID") returns nothing
This is my first attempt to use MSXML2.DOMDocument within VBA, and I'm having a "huh?" moment right off the start. My document looks like this...
etc.
I…
Maury Markowitz
- 9,082
- 11
- 46
- 98
0
votes
2 answers
VBA Excel MSXML2.XMLHTTP getelementsbytagname() not working
Here is my code
Sub loadrss()
Dim http As Object, html As New HTMLDocument, topics As Object, titleElem As Object, topic As HTMLHtmlElement, i As Integer
Set http = CreateObject("MSXML2.XMLHTTP")
http.Open "GET",…
vian
- 11
- 1
- 1
- 4
0
votes
2 answers
Write XML string directly to XML file with VBScript
My OS is Windows 7 64Bit. I need to write the following XML string along with interpreted dynamic content to an XML file (also maintaining the tabs indentation) by using VBScript:
File Name: [Variable1]_[Variable2].xml
VST
- 131
- 1
- 10
0
votes
0 answers
MSXML2.XMLHTTP , Method 'open' of object 'IServerXMLHTTPRequest2' failed
Dim objHTTPRequest As MSXML2.XMLHTTP
Set objHTTPRequest = New MSXML2.XMLHTTP
With objHTTPRequest
.Open MethodName, strRequest, Asynchronous, strUserName, mstrPassword
'___________more code here___________
End with
I am trying to create…
ApsSanj
- 549
- 7
- 23
0
votes
1 answer
Error 91 upon repeated extraction from external link
My function extracts exchange rate from an external website.
I can extract a single rate for a specific date.
I get error 91 when I have a list of different dates and I copy-paste the function to that whole list. (I tell Excel to apply this function…
Tango_Mike
- 104
- 11
0
votes
0 answers
How to speed up VBA web scraper by using MSXML2.XMLHTTP instead of InternetExplorer.Application
I've just started learning VBA a couple of weeks ago so i apologise if my work has any obvious errors. I've written some code that successfully scrapes data from tables on a website, the problem is that it runs very slowly. I am aware that using…
P McC
- 1
- 2
-1
votes
1 answer
Multiple css selectors vba
I have a case where I am trying to scrape multiple pages, but I noticed that the desired part to scrape is different sometimes and this makes me to use IF statements to check for the existence of object like that
Set obj = html.querySelector("div >…
YasserKhalil
- 9,138
- 7
- 36
- 95
-1
votes
1 answer
Invalid procedure call or argument: 'xmlDOM.load'
when I a get the XML url from a recordset I get this error
Invalid procedure call or argument: 'xmlDOM.load'
Set xmlDOM = CreateObject("MSXML2.DOMDocument")
xmlDOM.async = False
xmlDOM.setProperty "ServerHTTPRequest", True
sql="select top 1 *…
Ali Sheikhpour
- 10,475
- 5
- 41
- 82