I am trying to download XML House roll call votes into excel using VBA to automate the process. When I try to run the script on my pc, it produces an error that reads: "DTD is prohibited", which is odd, because the exact same script works fine with the XML Senate roll call votes. My code is as follows...
ActiveWorkbook.XmlImport URL:= _
", ImportMap:= _
Nothing, Overwrite:=True, Destination:=Range("$A$1")
how do I get around this error?