Registered forum members do not see this ad.
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??




Registered forum members do not see this ad.
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.
Bookmarks