Do a full install of your AutoCAD and then look in the Samples\VBA and
directory. There you will find two xmples of what you want to do - here are
their descripttions right out of the help file:
-attext.dvb: This sample extracts data from a drawing and puts the data
into Microsoft® Word and Microsoft® Excel files. This sample requires
Microsoft® Office 97 or Microsoft® Office 2000. Before using this sample,
open the attrib.dwg sample drawing file in the ExtAttr directory. To use
the sample, run the macro named Extract_Dialog.
-ExcelLink.dvb: This sample creates an Excel workbook that contains a bill
of materials (BOM) for the current drawing. After the BOM has been edited
in Excel, the data from the workbook can be passed back into the drawing.
This sample requires Microsoft Office 97. Before using this sample, open
the attrib.dwg sample drawing file in the ExtAttr directory. Before
updating a drawing, make the workbook with the BOM active.
As for allfro's offer, I would wonder about someone who isn't even aware of
the samples Autodesk provides :)
___________________________
Mike Tuersley
CADalyst's AutoCAD Clinic
Rand IMAGINiT Technologies
