Results 1 to 4 of 4

Thread: Link between Excel and CAD

  1. #1
    Member
    Join Date
    2017-03
    Posts
    16
    Login to Give a bone
    0

    Default Link between Excel and CAD

    Dear Experts,

    I am looking for a way to extract my block attributes, that once I click the attribute value in Excel, I want that block to be highlighted in autocad to identify where it is located. Basically, I want a relationship that in one program one instance is selected and it shows in other, or at least I select in excel and it highlights in autocad. The purpose behind this is we have some non CAD Users in asset management and they only use Excel and this possibility will help them big time.

    Any help from 'the experts' will be greatly appreciated.

  2. #2
    All AUGI, all the time
    Join Date
    2003-07
    Posts
    555
    Login to Give a bone
    0

    Default Re: Link between Excel and CAD

    Google this problem Autocad + Excel+ Handles every object does have a unique id so Block1 multi times still has individual id's

  3. #3
    Member
    Join Date
    2013-02
    Posts
    13
    Login to Give a bone
    0

    Default Re: Link between Excel and CAD

    There is a thread with an Excel workbook which should give you some direction on how to solve your problem.

    http://forums.augi.com/showthread.ph...xtraction-Tool

    I've been updating the workbook for ACAD 2017. Still a work in progress, but you're welcome to my version.
    Attached Files Attached Files

  4. #4
    Member
    Join Date
    2017-05
    Location
    CA
    Posts
    2
    Login to Give a bone
    0

    Default Re: Link between Excel and CAD

    Why not use MS Access it has a lot more power and flexibility. You could give a Access form to look at. They select the block and it shows all the attributes. You can use Access to extract all the block attributes into a table to drive the form. Here is a video to show some of the uses.
    Last edited by pmerola1008; 2017-05-19 at 09:45 PM.

Similar Threads

  1. 2012: Link between Excel and CAD
    By iangold in forum AutoCAD General
    Replies: 6
    Last Post: 2017-03-30, 10:39 PM
  2. Link to MS Excel
    By Wish List System in forum AutoCAD Wish List
    Replies: 0
    Last Post: 2013-11-15, 10:00 AM
  3. excel data link
    By miguelcid in forum AutoLISP
    Replies: 6
    Last Post: 2010-10-27, 03:30 PM
  4. Bi-directional excel link
    By djn in forum Revit Structure - General
    Replies: 5
    Last Post: 2008-03-29, 07:56 PM
  5. An active link (Excel OLE)
    By stephen.coff in forum AutoCAD General
    Replies: 11
    Last Post: 2005-11-06, 07:03 PM

Posting Permissions

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