AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

Reply
Contributor
19 Posts
0 Kudos
Registered: ‎03-27-2012
Post 1 of 2

Changing Part Descriptions using excel

107 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
166 Posts
9 Kudos
Registered: ‎06-16-2008
Post 2 of 2

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
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!