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.
Hope you can help out here.
tHANKS xtmhl coder.
Is this MSXML any use to me then. I am trying to http post the following xml code using Excel VBA.
XML Code which I've got to type somewhere. I have it on dreamweaver but don't know how to connect it to the http post code I have in VBA.
<?xml version="1.0" encoding="utf-8"?>
- <GovTalkMessage xsi:schemaLocation="http://www.govtalk.gov.uk/CM/envelope http://xmlgw.companieshouse.gov.uk/v1-0/schema/Egov_ch-v2-0.xsd" xmlns="http://www.govtalk.gov.uk/CM/envelope" xmlns:dsig="http://www.w3.org/2000/09/xmldsig#" xmlns:gt="http://www.govtalk.gov.uk/schemas/govtalk/core" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <CompanyDetailsRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlgw.companieshouse.gov.uk/v1-0/schema/CompanyDetails.xsd">
<CompanyName>TEST COMPANY PLC</CompanyName>
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.
Hope you can help me out.
If my memory serves me correctly it is actually a set of drivers and services fixes so wouldn't require an icon, it would install into something like C:\WINDOWS\... and integrate there.