Hi there..

I am now using AutoCAD 2013.. Is it possible to change hatch layer via excel input through VBA or LISP? Or other methods?

I have a plaza floor plan with each hatch for each unit (room) to represent unit type. 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).

Is is possible to update layers in AutoCAD automatically when we change unit type in column B? For example: Unit No. 001 change from Small Shop to Food, and Unit No. 005 change from Hypermarket to Cinema.., and then the layer in AutoCAD updates automatically. The floor plans contains about 300 units and 50 different layers to represent unit type. If this is possible, it would save the amount of time & effort than selecting hatch one by one and change the layer.

I have never used VBA nor LISP before., but I eager to learn.
Any clue will be much appreciated..

Regards,
Bagus