#1
|
|||
|
|||
Extract Heirarchy from SOURCE window
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? Last edited by ChrisOK; 01-04-2018 at 09:32 PM. Reason: added 4 pieces needed and disclaimer |
Tags |
xml mapping, xml source |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Extract Between the Parens | ChrisOK | Word VBA | 18 | 11-16-2017 12:59 PM |
Open different (additional) document in same window - view two documents side-by side in one window | MANOHAR | Word | 5 | 11-14-2017 03:06 AM |
Extract name and address. | donlincolnmsof | Word VBA | 1 | 11-10-2017 12:59 PM |
Extract Min and highlight cell from source | LeilaniMerle | Excel | 3 | 01-26-2014 11:05 PM |
Extract Photographs | The Gap | PowerPoint | 4 | 04-22-2010 07:00 AM |