Excel.....again!
Excel.....again!
(OP)
I have a number of Excel spreadsheets with northing and easting coordinates in the first 2 columns. In the 3rd column I have a station # (these spreadsheats are location and names for GPS monuments). Is there away to use the northing and easting to place a point in my drawing and have the point # automatically label the corresponding point.





RE: Excel.....again!
If so, a VBA routine could be written to pull in the datapoints. Once they were in the drawpoint method could be used to plot and label the points.
If you can confirm the question above and don't know how to use VBA, let me know and I'll slap some skeleton code up here.
RE: Excel.....again!
Actually the columns are easting, northing, station # (I switched the northing/easting on my previous post) But to answer you question YES they are considered X & Y in their appropriate coordinate system. Also I am a beginner with .lsp and no nothing about VBA. Any help would be greatly appreciated.
RE: Excel.....again!
-insert blockname xcoord,ycoord 1 1 0 Sta#
Cut and paste this column of data (commands) into AutoCAD's text window and you should be on your way.
RE: Excel.....again!
You lost me at "concatenate". I understand pasting in a comma delimited excel file into CAD to place my blocks in known locations. But I don't understand what or where to write a formula within Excel telling it to label the sta#'s?
RE: Excel.....again!
=CONCATENATE("TestBoring"," ",C2,",",B2," 1"," 0","z1992-",A2)