Hello
Ive written some vba that transverses a directory structure and finds all links within Excel files. It then stores this in a spreadsheet ie:
Column A is the spreadsheet containing a link , column b is the linked spreadsheets name
The code works fine, the next step is I want a visual representation of this so its easy (er) to see the links between each sheet.
I thought of Visio and its organigram wizard but it obviously doesnt like a subordinate linking back to a master
Does anyone have any ideas on how to display this data graphically?
Thanks!
Ive written some vba that transverses a directory structure and finds all links within Excel files. It then stores this in a spreadsheet ie:
Code:
ColumnA ColumnB
Sheet1 Sheet2
Sheet1 Sheet3
Sheet2 Sheet1
Sheet2 Sheet3
Sheet3 Sheet1
Sheet3 Sheet2
Sheet4 Sheet5Column A is the spreadsheet containing a link , column b is the linked spreadsheets name
The code works fine, the next step is I want a visual representation of this so its easy (er) to see the links between each sheet.
I thought of Visio and its organigram wizard but it obviously doesnt like a subordinate linking back to a master
Does anyone have any ideas on how to display this data graphically?
Thanks!
