Adding fillet radii to Created FreeForm Shapes

[Goose62]

I am trying to draw a cross section in Excel 2007 using VBA and node coordinates. I can draw the cross section using the build Freeform Shape Command and then use ConvertToShape. It looks great but retangular. I provide the corner node coordinates (X & Y) and a radius for that corner (0 if no radius at the corner) in an worksheet. I would like to be able to draw the fillets or radii at the corners if they are provided. Not sure how to do this is VBA.

Thanks for your help.

These are the coordinates below: Nodes 1, 2, 6, & 7 should have a radius in the shape.


Node ID X Y Radius
1 0.000 0.480 0.000
2 0.000 0.980 0.160
3 1.988 0.980 0.160
4 2.057 0.003 0.000
5 2.017 0.000 0.000
6 1.951 0.940 0.120
7 0.040 0.940 0.120
8 0.040 0.480 0.000

 

[pbornemeier]

Look at http://www.mrexcel.com/forum/excel-questions/498032-freeforms-visual-basic-applications.html

 

[pbornemeier]

2 PDFs of interest
http://www.ce.sc.edu/DeptInfo/membe...CIV 301/Building Freeform Shapes in Excel.pdf

http://www.cse.unsw.edu.au/~en1811/VBA_Drawing_withExcel2007-V1.pdf

 

[pbornemeier]

It may be easier to use Excel to control Visio to generate your diagrams. Use Google to search this site for:
VBA Visio From Excel site:mrexcel.com

Also Visio Guy is very useful