HELLLP! Been searching high and low for weeks w/ a deadline approaching and can't find a way to extract what is seen within the XML SOURCE window of an Excel file. (found on the 'Developer' tab > Source)
Normally wait a few days before resorting to a cross-post to try to find help - but due to deadlines, I'm adding a post disclaimer:
https://www.excelforum.com/excel-pro...ml#post4814674
Attached is a blurred image for a level of privacy -- but you can see the several tiers of the Parent Child relationships. (there's at least 6 tiers)
I simply need everything that's on this list to be layed into a spreadsheet or doc.
Ideally, if it could mirror the architecture that'd be great to see visually at a glance how many layers deep an element lies...
Heck, I'll even take it in a hard to read layout like:
Level.........Name........
1..............Abc (which is obviously the parent as a '1')
2..............Bbc (level 2 is a child to the parent listed above it)
3..............Ccc (level 3 here is a child to the child)
1..............Ddd
2..............Eee
1..............
2..............
3..............
4..............
5..............
6..............
Ultimately the client needs to see (with as much ease as possible) a full list of everything in that map... to gauge magnitude... 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.
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
I'm finding that it is leaving out the PARENTS which is a critical piece...
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!
The main 4 hings 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)
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 --
Any ideas how to pull out what's being displayed visually within the Excel files XML Source window?