I also don’t limit the solution for those 2 programming language, any clue will be much appreciated… I have never used VBA nor LISP before., but I eager to learn. If this is possible, it would save the amount of time & effort than selecting hatch one by one and change the layer. The floor plans contains about 300 units and 50 different layers to represent unit type. 005 change from Hypermarket to Cinema., and then the layer in AutoCAD updates automatically. 001 change from Small Shop to Food, and Unit No. Is is possible to update layers in AutoCAD automatically when we change unit type in column B? For example: Unit No. I also have an Excel spreadsheet that contains room number in column A (001, 002, 003,…, etc) and unit type in column B (Small Shop, Food, Hypermarket, Cinema, Department Store, etc). I have a plaza floor plan with each hatch for each unit (room) to represent unit type. I am now using AutoCAD 2013.Is it possible to change hatch layer via excel input through VBA or LISP? or maybe another method like MS Access etc. You can find it and all of my posts related to Microsoft Excel by clicking the Excel tag below. Update: If you found this post helpful, you might also be interested in my other post titled “ Quickly Link Excel Tables to AutoCAD “. So there you have it, a quick run-through on how to harness the new Data Links in AutoCAD 2008. As a deliberate checks and balances, to update the Excel file, you must right-click once again, and select “Write Data Links to External Source“. To modify a table value in AutoCAD, select a cell, right-click, and navigate down to “Locking”, and select “Unlock”.Īfter unlocking a cell, you can click into a cell, change a value. By default however you will not be able to update data from AutoCAD, and have it update in the source Excel document.
0 kommentar(er)
