
Figure 1
If someone gives you an excel file or text file of coordinates to plot in your AutoCAD, what will you do?
It is time consuming to type all coordinates values in specially when
there are lots of points to plot or the values are in hundred thousands
eg. 123456,7890123,0…
This VBA program let you copy and paste your excel file table of three columns consisting of your X, Y, Z column. If there is no Z value then just type 0 (zero). No empty cell is allowed for each point. The program also allows you to choose if you want to connect those points like say for alignment purposes or boundary.

Figure 1
Most of the time we use to get coordinates of every point of an alignment or boundary using polyline or 3D polyline.
What we normally do is use the “ID” command to get the coordinate (x,
y, z) then copy and paste to text or table. We also need to create a
call-out for each point to identify the location of specified
coordinates (see Figure 1).
This VBA program will create all of this automatically for you. What you need is just select the polyline or 3D polyline then it will generate tables with coordinates inside plus call out.
If you have any question just leave your comment…