I have Windows 7 and have downloadded MSXML onto my computer - it says it has finished installing, but I cannot find any icon after using the installer file. Nowhere to open up MSXML. Does anyone know what’s wrong here. This is the link for the official MSXML version 6 download.
This is the Eccel VBA command I have to use as the http post;
Set objHTTP = CreateObject(“MSXML2.ServerXMLHTTP”)
URL = “http://xmlgw.companieshouse.gov.uk/v1-0/xmlgw/Gateway "
objHTTP.Open “POST”, URL, False
objHTTP.setRequestHeader “User-Agent”, “Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)”
I have typed the above xml code in the same Excel vba too but it does not recognise the code. How can I post this code. I thought the MSXML was used to code xml and then connect to excel VBA using the 'Tools’and ‘References’ Menu in VBA.