radiantjoy
asked on
Changing all Visio 2003 shapes to another template's shapes
I will be creating an extension Org Chart of an internal website that will contain over 1000 hyperlinks based on data in an Excel spreadsheet.
Is there a way to change the formatting by way of swapping out all Tier 1 shapes for another shape ("Big Station"), all Tier 2 and 3 shapes ("Small Station")for another shape automatically? I need the custom properties, including the hyperlinks, to remain when swapping over.
I'm attaching 3 files, 2 of which a wonderful EE Expert helped build using Visio's wizard and Excel VBA/macros:
Prototype-org-chart.vsd contains the auto generated org chart from the
Prototype-modified.xls.
Desired shapes prototype contains the shapes (Big Station, Small Station) I want to switch to so that I can manually reformat the drawings, some of which will be quite convulated/lengthy when the exercise is done.
Thank you for your consideration! prototype-org-chart-1-.vsd prototype-modified-1-.xls Desired-Shapes-prototype.vsd
Is there a way to change the formatting by way of swapping out all Tier 1 shapes for another shape ("Big Station"), all Tier 2 and 3 shapes ("Small Station")for another shape automatically? I need the custom properties, including the hyperlinks, to remain when swapping over.
I'm attaching 3 files, 2 of which a wonderful EE Expert helped build using Visio's wizard and Excel VBA/macros:
Prototype-org-chart.vsd contains the auto generated org chart from the
Prototype-modified.xls.
Desired shapes prototype contains the shapes (Big Station, Small Station) I want to switch to so that I can manually reformat the drawings, some of which will be quite convulated/lengthy when the exercise is done.
Thank you for your consideration! prototype-org-chart-1-.vsd prototype-modified-1-.xls Desired-Shapes-prototype.vsd
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It's not impossible... but it's not easy! I would definitely fiddle with option #1 above to see the various format that the org chart wizard provides.
If you decide that you REALLY want to try option #3, post another question specifically about that and I'll do some experimenting to see what's possible.
Scott
If you decide that you REALLY want to try option #3, post another question specifically about that and I'll do some experimenting to see what's possible.
Scott
ASKER
Ok, great! Let me see what the normal org chart yields.
Thank you, again!
Thank you, again!
ASKER