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:

Please Login or Register  to view this content.
I need further guidance to transfer the Namespaces URL / Schema Location / Elements (in Nodes), their attributes, values, etc to Different Worksheets in Excel.

Thanks