saiid Posted November 5, 2013 Share Posted November 5, 2013 Dears; could anybody help me to have macro for locating lots of instruments with coordination (E,N,) and Name from Excel to AUTOCAD. attached is sample excel file that required to locate in CAD. Coordination Report.xls Tanx Quote Link to comment Share on other sites More sharing options...
saiid Posted November 5, 2013 Author Share Posted November 5, 2013 Dears; could anybody help me to have macro for locating lots of instruments with coordination (E,N,) and Name from Excel to AUTOCAD. attached is sample excel file that required to locate in CAD. Coordination Report.xls tanx Quote Link to comment Share on other sites More sharing options...
MSasu Posted November 5, 2013 Share Posted November 5, 2013 What is the meaning of first column? Are about some blocks? Those reside in your drawing or were stored on a disk? You may build by yourself a script from that Excel file, don't need a dedicated tool. By tha way, don't need to duplicate your thread, please ask a moderator to remove one of them. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted November 6, 2013 Share Posted November 6, 2013 Search here for excel & Contactenate command what you want is real easy like MSasu says excel column = insert AIT-17007 3468299,4509976 1 1 0 use =CONCATENATE("insert ",A6," ",C6,",",E6," 1 1 0") just copy column and paste directly into command line Quote Link to comment Share on other sites More sharing options...
KevUK Posted November 6, 2013 Share Posted November 6, 2013 Hi saiid Perhaps do a search for script or look through the AutoLISP, Visual LISP & DCL section. http://www.cadtutor.net/forum/forumdisplay.php?21-AutoLISP-Visual-LISP-amp-DCL Even have a look at Lee Mac excellent Pt Manager lisp routine. http://lee-mac.com/ptmanager.html Quote Link to comment Share on other sites More sharing options...
saiid Posted November 6, 2013 Author Share Posted November 6, 2013 Hi Kev Tanx so much, i loaded above mentioned lisp file in my outocad, but i need some explanation for importing and indicating data such as name, E, N for each point from excel file to CAD. would you please help me. Tanx so much indeed. Quote Link to comment Share on other sites More sharing options...
KevUK Posted November 7, 2013 Share Posted November 7, 2013 As I mentioned before, do a search, this topic has been covered numerous times previously. Quote Link to comment Share on other sites More sharing options...
Tiger Posted November 7, 2013 Share Posted November 7, 2013 Saiid, I merged your two threads - please do not ask the same question multiple times across the forums. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.