LINKING EXCEL WITH ACAD BLOCKS

[Anonymous]

Is there a simple way to assign attributes blocks using an Exel reference?

I've attached a dwg with a block that has different pieces of info on it. I'd like to just put the Detail Reference in and then run a VBA and it would put the rest of the info in for me by referencing an Excel spreadsheet. That way I can set up the formulas on the spreadsheet and let VBA fill in the attributes.

[Anonymous]

I figured it out....

I updated the spreadsheet to filename.xlsx

That way the type library matched the file in use.

I'll play with it now and get back to you. THANKS!!!!

M Message was edited by: MikeENGHome

[Anonymous]

I guessroblem is on your Excel version
Try to change this line:
Set ObjExcel = CreateObject("Excel.Application.11")
on another one
Set ObjExcel = CreateObject("Excel.Application.12")'<--I am not sure about
I don't know exactly what the numeric version
will be for the Excel 2007
I feel that there is a long deal here
If you want, let you send your opinion
directlly to me fixo@yandex.ru
I'll free on this weekend for programming

~'J'~

[Anonymous]

hi  can u help me ,

i need to assign a variable say A to  value 5 wich can be set using the (setq a 5 ) in autocad command prompt

but can any one tell me how can i assign it thru  excell vba code  plse and soon