AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

Reply
Contributor
nothin
Posts: 19
Registered: ‎03-27-2012
Message 1 of 2 (105 Views)

Changing Part Descriptions using excel

105 Views, 1 Replies
03-30-2012 03:26 PM

I have a set of part descriptions that need to be changed. Each part description corresponds to a part number. See the example below of what it would look like in AutoCAD.

 

123     screw

265     bolt

847     washer

 

But this list can get really long. Each part number and each description is a seperate text string or mtext string.

 

I plan on having an excel spreadsheet that has a list of all part numbers that my company uses with their corresponding descriptions.

 

I would like to use the part number to find the appropriate description and then change the description.

 

Hopefully this can be done automatically for a list of part numbers and their descriptions.

 

Is there a way to do this?

Mentor
BrentBurgess1980
Posts: 162
Registered: ‎06-16-2008
Message 2 of 2 (88 Views)

Re: Changing Part Descriptions using excel

04-02-2012 12:46 AM in reply to: nothin

i might have picked up the wrong end of the stick, but have you looked at the datalink manager (Tools -> Data Links -> Data Link Manager...)

 

You can link the excel sheet to the drawing, similar to an xref, so when the excel file changes, you will get a notification bubble down the bottom right

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.