Populating a dialogue box with attributes from a autocad title sheet

[sscott5]

Can anyone help

I'm like to write a macro that will pull the attributes from an Autocad drawing and place them in a dialog box, which I will export to excel.

My VBA skills are rather limited so any advice would be most welcome.

Regards New Member

[Ed Jobe]

There's a vba project that comes with acad that does that. Just make sure you installed the sample files.

[MikeJarosz]

Why not make your title block an ACAD table with fields? Acad then allows you to export a table as a comma delimited file. No VBA neccessary here. If you haven't discovered fields yet, you are missing the best new feature in Acad in a while.

You need 2005 or 2006, preferably '06.

[adamc]

AutCAD 2005 and 2006 have an attribute extraction tool (Tools>Attribute Extraction) that does exactly what you are asking for. It uses a wizard type dialog box that goes through a few steps to allow you to filter out what attributes you want export and then you can export to several different formats, .xls being one of them. This may be what MikeJarosz is talking about but maybe he has a different method too. Good luck

[MikeJarosz]

AutCAD 2005 and 2006 have an attribute extraction tool (Tools>Attribute Extraction) that does exactly what you are asking for. It uses a wizard type dialog box that goes through a few steps to allow you to filter out what attributes you want export and then you can export to several different formats, .xls being one of them. This may be what MikeJarosz is talking about but maybe he has a different method too. Good luck

Not really. Attribute extraction from blocks in Acad is old hat. Check out attext and ddattext. Fields and tables are a whole new ballgame. For example, a field can be linked to the area of a polygon. The field will display the poly area on the drawing and update when the poly changes. Or it can display the filename of the drawing. If I do a saveas to a new filename, the field will update to the new filename.