Link between Excel and CAD

[iangold]

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.

[BIG-AL]

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

[MICHAEL.JONES]

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.php?86113-VBA-and-ObjectDbx-AutoCAD-to-Excel-Attribute-Extraction-Tool

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

[pmerola1008]

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. https://youtu.be/xpcFtGJpark