I have recently converted my way of loading libraries/references from the usual VBA way (Tools->References) to more of a late binding way (CreateObject("Referencena
me")) and I have problems with loadXML in my Msxml2.DOMDocument.3.0. I use MS Excel to generate an XML string and then I try to load it and save it to a folder, but the XML I save always turn out blank, whilst the text I have generated always looks quite ok (attached).
So I wonder what I am doing wrong, and what I have to do to make the generated XML save properly.
Any help appreciated,
<?xml-stylesheet type="text/xsl" href="ex_avviksmelding.xsl"?>