Hi,
cross posted from here:
https://social.technet.microsoft.com/Forums/office/en-US/f84e8135-854f-4192-8658-1e3651ccb021/drawing-crows-foot-diagram-from-excel-data-file?forum=visiogeneral (https://social.technet.microsoft.com/Forums/office/en-US/f84e8135-854f-4192-8658-1e3651ccb021/drawing-crows-foot-diagram-from-excel-data-file?forum=visiogeneral)
i have pattern like below and i would like to draw crow's foot diagram from this.
Please help how to do it.
Best,
Jacek
Hello Jacek,
my advice would be to dissect the task in smaller ones (e.g. draw an entity, set its name, its ID, position it, etc.). The necessary commands can be found by recording your own actions with the macro recorder.
Next you would find out how to edit the attributes and how to add relation connectors between the attributes.
Working with the macro recorder requires some basic knowledge like:
- differentiating between important stuff and "decorations". For instance you usually don't need the diagram services stuff, nor the undo functions.
- understand that "ActiveWindow.Select Application.ActiveWindow.Page.Shapes.ItemFromID(223)" is only a shape object that can be defined otherwise (like " set shp = activewindow.selection(1) ").
HTH,
Y.
Hi Yacine,
thank you.
I will create new topics for it.
Best,
Jacek