On the 31st August my code to retrieve data from a website suddenly failed with this error.
I have 4 PC's, two of them have exactly the same configuration (Windows 10, Office 365 Business) and the code fails on one and works on the other. The other two are both Windows 7 and the code works perfectly as well. The code fails at the xml.send command with this error.
Set xml = createObject("MSXML2.xmlhttp")
xml.Open "POST", sSelectedurl, False
xml.Send
To make this more confusing the code is in a loop. At each loop the URL is updated with the page number to retrieve data that is on multiple pages and it retrieves the first product on 4 pages successfully and then the URL is changed to retrieve the first page of the second product it fails but only on the one PC.
This program is distributed widely and so far I have had two other users report the same problem. Given the distribution, this is relative low but each reports the program working successfully until August 31.
I have tried removing all Microsoft updates but that did not work. I have tried various changes to the code but that does not work either.
This is way too deep for me and any help would be greatly appreciated. I am willing to try anything to get this fixed so all suggestions welcome (no matter how weird they are).
Bookmarks