AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

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

Changing Part Descriptions using excel

106 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: 166
Registered: ‎06-16-2008
Message 2 of 2 (89 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
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.