Hi
I want to import XSD / XML files in Excel VBA using MSXML2 and DOM.
The XSD / XML files have various - Namespaces & their URLs / Parent and Child Nodes.
I want to Import them into various Worksheets Excel such as One for Namespaces / Schema Location / Elements (in Nodes), etc.
I have written a small basic code to Open File Dialog Box & Load the XML / XSD Doc:
I need further guidance to transfer the Namespaces URL / Schema Location / Elements (in Nodes), their attributes, values, etc to Different Worksheets in Excel.
Thanks
Bookmarks