PDA

View Full Version : coordinates form excel cells to an autocad drawing



sTixi
29th Jun 2005, 08:39 pm
Hello i have this informations below in an Excel sheet in different cells and want to take this informations as points in an autocad drawing. Each coordinate information like x is in an own cell...
-------- |x y z
-------- |---------
Point 1 | 1 1 1
Point 2 | 2 1 1
Point 3 | 3 1 1

how can i do this in AutoCAD VBA?

can some one help me??

CarlB
29th Jun 2005, 10:32 pm
You can do it without lisp or vba.......

Short reply, you might serch this site for more discussion.

Say x, y and z are in columns B, C, and D in Excel. In column E (cell E1), formulay is =B1&","&C1&","&D1 to get a column with format "x,y,z". Copy this down as needed.

(you could also use the "concatenate" function).

In AutoCAD type MULTIPLE <enter> POINT <enter>

then copy and paste points from column E into the command line. This should create all the points. ESC to end the command.