What is the best way to link Autocad and Excel?

[Samuadam]

Hi,

I have to link attributes from autocad with excel. I see how do it with visual lisp or VBA but I don't know wath is the best way and if an other way exist.

Could you help me to choose.

Best regards

Sam

[Anonymous]

There is no best way. It all depends what language
you're writing your program in.

If you use vlisp however, you had better import the
type library. The Excel type library contains an awful lot of methods,
properties and constants...

style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

Samuadam <
href="mailto:samuadam@hotmail.com">samuadam@hotmail.com> wrote in
message
href="news:f0850d9.-1@WebX.maYIadrTaRb">news:f0850d9.-1@WebX.maYIadrTaRb...

Hi,

I have to link attributes from autocad with excel. I see how do it with
visual lisp or VBA but I don't know wath is the best way and if an other way
exist.

Could you help me to choose.

Best regards

Sam

[Samuadam]

Thank you Guido, I know the types library and you have got a lot of methods.
What I would like know it is if a method exists to link directly the data and not have to open excel every time I must read a drawing in autocad.

[Anonymous]

Yes, you can link directly to the Excel spreadsheet without opening
Excel.

You have to treat the Excel spreadsheet as a database. You must set up
your data in rows, with column names in the top row. You must select
all the cells containing your data and column names and make that a
"Named Range". The name of the named range is the name of your
database table.

Then you use ActiveX Data Objects (ADO) to access that table.

For a library for LISP to do that, see the download page at
http://www.fleming-group.com.

There's lots more discussion of similar subjects in the
autocad.connectivity newsgroup.

jrf
Member of the Autodesk Discussion Forum Moderator Program
Please do not email questions unless you wish to hire my services

In article , Samuadam wrote:
> Thank you Guido, I know the types library and you have got a lot of
> methods.
> What I would like know it is if a method exists to link
> directly the data and not have to open excel every time I must read
> a drawing in autocad.
>

[Anonymous]

Went to your homepage.
Contains interesting stuff. Recommendable...

Greetings,
Guido Rooms