Drawing Crow's foot diagram from Excel data file

Started by jaryszek, November 30, 2018, 07:53:44 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jaryszek


Yacine

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.
Yacine

jaryszek

Hi Yacine,

thank you.

I will create new topics for it.

Best,
Jacek