Change block layer through excel lookup

[aw.265109]

Dear Clever People!

We have an excel table with two columns: Name & Value
We are looking for a way to have a block lookup the table, check for the row with its own name find the value.
Then using the value either change the blocks layer or change the objects hatch colour accordingly.

Eg
1=red, 2=green, 3=blue,

Possible Steps.
1. On lisp run from cmd or button.
2. Search for all blocks in current drg.
3. Use block name. (Or other attribute value if eaisier)
4. Lookup excel file sheet 1.
5. Find block name in column A.
6. Return value from same row in column B.
7. Use value from column B to either move the block to a layer by the value or edit the colour of blocks hatch to the column B value.

I have looked at a lot of forums in search for this but can't see anything that would work..anyone any ideas?

[dgorsman]

Are you searching on the overall idea? Have you tried searching on the steps you've outlined?

[BIG-AL]

Poor mans answer is to do a csv dump of the excel, and just read that file. In excel create a macro for the csv bit so it writes 1 file only.

2nd better answer google excel <-> Autocad lots of example code.