"Last row written to = " & destCell.Row + rowOffset - 1 MsgBox "Finished parsing internal XML schema '" & XMLinternalSchema.Name & "' in XML map '" & & "'" & vbNewLine & vbNewLine & _ Scan_ElementsToCells XMLdoc, XMLmainNode, destCell, rowOffset, 0 Set XMLmainNode = XMLdoc.SelectSingleNode("//xs:element Not XMLmainNode Is Nothing Then All data elements are contained in this node SetProperty "SelectionLanguage", "XPath" 'How To Specify Namespace when Querying the DOM with XPath. 'Set XMLdoc = CreateObject("MSXML2.DOMDocument.6.0") 'for late binding MsgBox "This workbook doesn't contain an XML schema" Set XMLinternalSchema = ThisWorkbook.XmlMaps(1).Schemas(1) Public Sub Extract_Internal_XML_Document_Structure() Thanks in advance - praying SOMEONE - ANYONE knows something about this window and how to get what's in it - OUT! Need help with some VBA or a method for grabbing everything in that window and pasting it either into an Excel sheet -or even into Word if that's easier -Īny ideas how to pull out what's being displayed visually within the Excel files XML Source window? The main 4 things I need are the PARENT, REQUIRED PARENT, CHILD and REQUIRED CHILD (based on the icons shown in the XML Source window, those are the 4 items I need a list of) So, I don't have any idea HOW MANY items are REALLY within that XML Source window because what got pasted is NOT all inclusive! Frustrating! I'm finding that it is leaving out the PARENTS which is a critical piece. When I select all, copy & paste everything in that XML Source window, (paste it long ways along row one of a sheet) - it holds over 8,000 items next to see how many parents there are - and determine how many levels inward they want us to go as a dev team - to tackle issues within a system. Ultimately the client needs to see (with as much ease as possible) a full list of everything in that map. Heck, I'll even take it in a hard to read layout like:ġ.Abc (which is obviously the parent as a '1')Ģ.Bbc (level 2 is a child to the parent listed above it)ģ.Ccc (level 3 here is a child to the child) Ideally, if it could mirror the architecture that'd be great to see visually at a glance how many layers deep an element lies. I simply need everything that's on this list to be layed into a spreadsheet or document. The image shows the several tiers of the Parent Child relationships within the EXCEL XML SOURCE window. With client deadline fast approaching and knowing that it's sometimes hard to visualize I recently posted on 2 sites that have the ability to upload a sample pic file - to better explain.Ĭross-post link disclaimer is available if seeing the uploaded visual is helpful: As a long time member of MrExcel, I'm hoping all the Aladin Akyurek genius-types of folks can provide some desperately needed help - I've been searching for weeks and not finding a *single soul* that knows anything on this topic or it's Excel functionality which seems shocking!?!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |