amjid — 2010-08-06T11:58:44-04:00 — #1
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 — 2010-08-07T05:46:05-04:00 — #2
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.
xhtmlcoder — 2010-08-07T05:10:07-04:00 — #3
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.