Excel Rectangle to AutoCAD

[bedros.j495613]

Hi,

i have an excel list of Length x Width (2 columns)

2400 50
2340 45
etc
etc

is there a way to DRAW Rectangles from the excel List in AutoCAD? End result i want Rectangles drawn near each other from the Excel List

SInce there are many Rectangles in AutoCAD, it should be done in a way to give a space between each item (i,e first one is drawn in 0,0 coordinate the other one can be drawn, 0,4000) 4 meters away

thanks,

Bedros

[Ed Jobe]

Yes, you can do it via lisp or VBA. You can search the vba forum for code samples on working with AutoCAD from Excel. If you don't want to place the rectangles at fixed distances, you can store 2D insertion points in xl.

[BIG-AL]

Stay in excel and do it all use enter your start co ords x y at top in 2 new columns also spacing x then its just some simple maths use concatenate to make a column that is the rectangle pt1 pt2. You need Rectang x1,y1 x2,y2. You just copy the column to the command line the rectangs will appear.