none
Adding namespaces to xml doc.

    Question

  • 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">

    Thanks

    Monday, June 24, 2013 10:11 PM

All replies

  • Hi Squik,

    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!

    Best regards,


    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.

    Tuesday, June 25, 2013 11:53 AM
  • 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

    Tuesday, June 25, 2013 1:03 PM
  • 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.

    Thanks

    Tuesday, June 25, 2013 1:34 PM
  • Hello Squik,

    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
    http://support.microsoft.com/kb/285329/EN-US

    Please let me know if you have additional questions after reviewing the article.

    Regards,
    Dennis

    Thursday, June 27, 2013 12:22 PM