Code

Re: Read InfoPath'07 XML using MSXML2 & VBA

dpenny — Thu, 10 Sep 2009 15:53:58 GMT

I got around my problem by letting MS Word navigate to & open directly the Infopath07 form. Then in VBA pick up the XPATHs to the data wanted by using the PRIVATE fields to specify the XPATHs. Then get the text data from the open Infopath form and plunk it into the Word template. The hardest part was handling repeating table rows from Infopath form.

Re: Read InfoPath'07 XML using MSXML2 & VBA

Hilary Stoupa — Thu, 10 Sep 2009 15:39:54 GMT

It might be helpful if you post your code...

Re: Read InfoPath'07 XML using MSXML2 & VBA

petebetelgeuse — Thu, 10 Sep 2009 11:38:46 GMT

Hi Just run into the same problem;I haven't solved it, but made some headway. First, it seems inconsistent between users (code works ok on my machine, but not others) - I've tried different versions of the Microsoft XML dll via VBA references, to no avail Interestingly, I can stop the error by opening the xml file in notepad and removing the line in standard infopath header as shown below (though this is by no means a fix - infopath just replaces the deleted line whenever the form is re-edited) .....

Read InfoPath'07 XML using MSXML2 & VBA

dpenny — Fri, 08 May 2009 19:16:56 GMT

How do I read and parse (select single node....) the Infopath'07 XML (data only) files using MSXML2 and VBA? I seem to be able to navigate and load the XML from SharePoint form lib but get a load error "only one top level element is allowed in an XML document."

Is it a valid XML file? The elements with no data are like: <my:WrittenBy1 /> Is there a different problem?