My application has been working fine for the last two and a half years. But today, all of the sudden I am getting the error:
Doing a little research this can be caused by a slew of possible reasons. I suspect it has something to do with a corrupted or altered system file or registry entry. I have not installed any new programs recently.
The error occurs when trying to access an HTML page. Here is the snippet of code where the error occurs.
The error occurs at the .send line
I am running:
Windows 7
Excel 2013
VBA 7.1
If anyone has any ideas or experience with similar issues I would be greatly grateful.
-Brian
Run-time error '-2147024891 (80070005)':
Access is denied.
Doing a little research this can be caused by a slew of possible reasons. I suspect it has something to do with a corrupted or altered system file or registry entry. I have not installed any new programs recently.
The error occurs when trying to access an HTML page. Here is the snippet of code where the error occurs.
Code:
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", URL, False
.setRequestHeader "User-Agent", UAgent
.send
TXT = .responseText
End With
The error occurs at the .send line
I am running:
Windows 7
Excel 2013
VBA 7.1
If anyone has any ideas or experience with similar issues I would be greatly grateful.
-Brian