MSXML and why doesn't it work

Amjid · August 6, 2010, 3:58pm

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.

Amjid

Amjid · August 7, 2010, 9:46am

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”>
<EnvelopeVersion>1.0</EnvelopeVersion>
<Header>
<MessageDetails>
<Class>CompanyDetails</Class>
<Qualifier>request</Qualifier>
<TransactionID>1</TransactionID>
</MessageDetails>
<SenderDetails>
<IDAuthentication>
<SenderID>89832659075595786501487630603942</SenderID>
<Authentication>
<Method>CHMD5</Method>
<Value>j3u4auinzxzlwpe2ru3qcgosbqqqz24p</Value>
</Authentication>
</IDAuthentication>
</SenderDetails>
</Header>
<GovTalkDetails>
<Keys />
</GovTalkDetails>
<Body>
<CompanyDetailsRequest xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=“http://xmlgw.companieshouse.gov.uk/v1-0/schema/CompanyDetails.xsd”>
<CompanyNumber>99999999</CompanyNumber>
<CompanyName>TEST COMPANY PLC</CompanyName>
<GiveMortTotals>1</GiveMortTotals>
</CompanyDetailsRequest>
</Body>
</GovTalkMessage>

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)”
objHTTP.send (”")

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.

Regards.

AMJID

xhtmlcoder · August 7, 2010, 9:10am

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.