using msMXL2 in VBA how can I add the following root element
<edgarSubmission xsi:schemaLocation="http://www.sec.gov/edgar/thirteenffiler eis_13F_Filer.xsd" xmlns="http://www.sec.gov/edgar/thirteenffiler" xmlns:ns1="http://www.sec.gov/edgar/common" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
Thank you for posting in the MSDN Forum.
I'm trying to involve some senior engineers into this issue and it will take some time. Your patience will be greatly appreciated.
Sorry for any inconvenience and have a nice day!
Quist Zhang [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
To what are you trying to add this root element? A Word document? A "plain" XML document? Something else?
What kind of problems are you running into when you try to create the element? Please show us the code you're using?
Cindy Meister, VSTO/Word MVP, my blog
I"m probably in the wrong forum. I just saw the word for Developers on top. Sorry about that.
I was trying to added to a simple xml file. I got it by doing
Call EdgarSubmissionElement.setAttribute("xsi:schemaLocation", "http://www.sec.gov/edgar/thirteenffiler eis_13F_Filer.xsd")
Call EdgarSubmissionElement.setAttribute("xmlns", "http://www.sec.gov/edgar/thirteenffiler")
Call EdgarSubmissionElement.setAttribute("xmlns:ns1", "http://www.sec.gov/edgar/common")
Call EdgarSubmissionElement.setAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance")
could you point me to the right forum? I'm creating a .xml file by using MSXML via ms access. I need to create the .xml based on information that's on tables.
Access can create an element-centric XML output of your tables for you by going to External Data > Export Group - XML.
If the built-in export doesn't give you the desired results or you need to export attribute-centric XML, then you can perform the export manually using ADO and XML 3.0.
The following KB article provides some sample code on importing/exporting XML with Access.
KB 285329 You cannot import attribute-centric XML in Access
Please let me know if you have additional questions after reviewing the article.