+ Reply to Thread
Results 1 to 8 of 8
  1. #1
    Forum Newbie
    Using
    AutoCAD 2013
    Join Date
    Nov 2013
    Posts
    3

    Question Locating of Instruments with coordinations in Excel to CAD

    Registered forum members do not see this ad.

    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

  2. #2
    Forum Newbie
    Using
    AutoCAD 2013
    Join Date
    Nov 2013
    Posts
    3

    AutoCAD Locating of Instruments with coordinations in Excel to CAD

    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

  3. #3
    Forum Deity MSasu's Avatar
    Discipline
    Construction
    MSasu's Discipline Details
    Occupation
    engineer
    Discipline
    Construction
    Details
    AutoLISP programmer
    Using
    AutoCAD 2013
    Join Date
    Mar 2009
    Location
    Brasov, Romania
    Posts
    4,008

    Default

    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.
    Regards,
    Mircea

    AutoCAD's happy user equation: FILEDIA + PICKADD² + PICKFIRST = 3

  4. #4
    Luminous Being
    Using
    Civil 3D 2016
    Join Date
    Dec 2005
    Location
    GEELONG AUSTRALIA
    Posts
    9,732

    Default

    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

    A man who never made mistakes never made anything

  5. #5
    Full Member KevUK's Avatar
    Using
    AutoCAD 2014
    Join Date
    Nov 2009
    Location
    UK
    Posts
    65

    Default

    Hi saiid

    Perhaps do a search for script or look through the AutoLISP, Visual LISP & DCL section.

    http://www.cadtutor.net/forum/forumd...l-LISP-amp-DCL

    Even have a look at Lee Mac excellent Pt Manager lisp routine.

    http://lee-mac.com/ptmanager.html

  6. #6
    Forum Newbie
    Using
    AutoCAD 2013
    Join Date
    Nov 2013
    Posts
    3

    Default

    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.

  7. #7
    Full Member KevUK's Avatar
    Using
    AutoCAD 2014
    Join Date
    Nov 2009
    Location
    UK
    Posts
    65

    Default

    As I mentioned before, do a search, this topic has been covered numerous times previously.

  8. #8
    Super Moderator Tiger's Avatar
    Computer Details
    Tiger's Computer Details
    Operating System:
    Windows 7 Professional 64 bit
    Computer:
    HP EliteBook 8570w
    CPU:
    Intel Core i7-3720QM 2.60GHz
    RAM:
    16GB
    Graphics:
    NVIDIA Quadro K2000M
    Monitor:
    HP
    Discipline
    Civil
    Tiger's Discipline Details
    Occupation
    Education /support
    Discipline
    Civil
    Details
    Support/Education/Retail
    Using
    Civil 3D 2016
    Join Date
    Nov 2006
    Location
    Fjärdhundra, Sweden
    Posts
    5,148

    Default

    Registered forum members do not see this ad.

    Saiid, I merged your two threads - please do not ask the same question multiple times across the forums.
    MTJIGSTRING = BAZINGA

Similar Threads

  1. locating cad blocks
    By mss3333 in forum AutoCAD Beginners' Area
    Replies: 1
    Last Post: 21st Sep 2011, 02:47 pm
  2. locating the block library
    By alijahed in forum AutoCAD Drawing Management & Output
    Replies: 4
    Last Post: 23rd Nov 2009, 03:17 am
  3. Locating a point on line etc
    By GREG in forum AutoCAD Beginners' Area
    Replies: 12
    Last Post: 27th Aug 2007, 07:41 pm
  4. Locating Extra Blocks
    By DYL in forum AutoCAD Drawing Management & Output
    Replies: 1
    Last Post: 2nd Nov 2005, 03:20 pm

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts