AutoCAD 2010 :: Changing Part Descriptions Using Excel
Mar 30, 2012
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.
View 1 Replies
ADVERTISEMENT
Apr 11, 2013
Some times we use standard parts which we could not find in content center. We creat part ourselves. But it looks like standard part in BOM or part explorer window...
I want to change type of part to PURCHASED type and icon like other purchased parts like bearings or bolts...
Is this possible?...
It can be also assembly parts like bearings. Bearings have many parts but it looks only one part in part explorer. This is very good. I want same thing too...
View 9 Replies
View Related
Apr 3, 2013
I want to make a map with 16 different plots (A1 to D4) in AutoCAD. Every plot in this map is connected to an excel file, where is some information listed (area, height, year, type) per plot. This map need to be dynamic, so by chosing what to see (for instance: area), the color of the parcels needs to change according to the value per plot (for instance: 12 m2 = yellow, 24 m2 = orange, 48 m2 = red). The two files I am using are send with it.
how to program this in VBA in AutoCAD. The shape of the plots I want to draw on my own (hatching each plot is also no problem), and somehow I need to name each plot (hatch). But how can I name the plots (hatches) and change the colour per plot (hatch) in VBA? The files I am using have 1600 different plots.
View 8 Replies
View Related
Jan 28, 2013
I have made a configurator, that defines my part. Now i would like to add some intelligence for the Save process...
When i activate my rule it should.:
1. Go to a Excel spreadsheet and find next Empty cell in a specific collum
2. Place Title from inventor in that empty cell
3. Return the value from the cell next to this cell
3. Use this value as the new filename for my part.
Example: here i would like to get the parts tile put into B3 and A3 (103) returned to Inventor as filename to my part
--------------------
A B C
1 101 Title1
2 102 Title2
3 103
If possible, i would like to be able to adjust this alittle as i go forward in my work,
View 9 Replies
View Related
Dec 6, 2011
I would like to link a cell value in excel with the partnumber from a assembly in Inventor. How can I made this link?
View 1 Replies
View Related
Aug 22, 2012
I want a part number which is made with a parameter write to excel to the excel sheet to link to acad. I have the following code that runs smoothly and requires the excel sheet to save but get nothing written in the cell.
GoExcel.CellValues ("M: AutoCAD AutoCAD 2012 Inteco3D File Test ExportPartNumber.xlsx", "Sheet1", "A1", "A10") = MultiValue.List ("Part Number")
View 4 Replies
View Related
May 12, 2012
I created a spreadsheet of about 40 rows to be used to create different parts. I then created a part "we'll call it Board_A". I linked to the spreadsheet and used 3 of the fields for my dimensions. Lets say I named the length (which was the extrusion number) as "Len_1". I saved it and all is well!! I then created other parts and used the spreadsheet for the dims. I then went back and opened "Board_A" and saved a copy as "Board_B". I closed Board_A and opened Board_B. I then rt clicked on "Extrusion" so I could change the length from "Len_1" to "Len_1_A" which is another row (field) on that same spreadsheet which is still linked. When I tried I received a message that said I couldn't do that (I forgot the actual message!) I clicked the Parameter icon and the only fields showing on the popup spreadsheet box were the ones I had previously used for those parts that I made from scratch. I thought I figured this out once but if I did I forgot. I deleted the spreadsheet link and then re-added it but nothing I have tried has worked. Is there a way to get these fields to be usable with a Copy of an existing part or do I just have to start from scratch and make the similar part?
View 1 Replies
View Related
Aug 15, 2012
iLogic rule that will retrieve a part number(s) from an excel sheet. I work for a company that built vacuum trucks and I'm trying to make an . I am template where the user can select different lengths of shells to achieve the desire overall length. I have been able to achieve this using iLogic rules and forms and making the shell length parameter multi value.
But now I need to show predetermined SAP part numbers for the shells in BOM or part list. I all ready have an excel sheet with shell sizes with corresponding part numbers on file. I also thought about incorporating our custom CC parts/shells that already have the SAP part numbers set up as a custom iProperty but might be to complicated for a newbie iLogic user.
View 9 Replies
View Related
Jan 27, 2012
linked Excel file to Inventor 12 file parameters. Windows 7, Excel MS office professional '10. Linked excel file, here dimensions are driven by parameters which are driven by excel. toggled 'immediate update' Still - i have to open the sketch - it shows the updated number from Excel, but only on opening the sketch will it change the model to use the new dimension value.
View 3 Replies
View Related
Jul 16, 2013
I am trying to link a Excel spread sheet to an Inventor 2009 part. It worked great on Friday now it is not working. The only thing that changed was that there was a windos update. When it does work I am unable to update any of the parametes that are linked to Excel file as the update button has disappear.
View 2 Replies
View Related
Oct 31, 2011
I created a part, then created an assembly and put the part in the assy. Now I have changed the name of the part but it still shows up as the origional name in the assy. How do I get the name in the assy to match the part?
View 9 Replies
View Related
Sep 8, 2011
How can I change transparency of a part within itself or within an assembly? (I.E. leave its original color as is, but changing/"tweaking" its transparency).
View 9 Replies
View Related
Oct 19, 2012
How to change the part that has the pushpin icon on it? i need to change the static part in my assembly.
View 2 Replies
View Related
Mar 24, 2012
Can export the repair details from dwg drawing prepared by asd in to excel by the use of auto cad?
View 3 Replies
View Related
Apr 3, 2012
I have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.
is there anything i can do to hide back some border lines for selected cells?
View 5 Replies
View Related
Sep 17, 2010
I created an assembly, so far with one part in it. I created an Excel spreadsheet with several dimensions in it that would be used in the assembly parts. I went to Manage>Parameters and linked the spreadsheet. The Excel file appeared in the Parameter Dialog Box with the parameters included in it. However, when I create a part in the assembly and attempt to dimension a sketch in it, the parameters option in the dimension box is not present.
I have done this in the past in IV2009, has anything changed that I cannot do so in 2010?
View 9 Replies
View Related
Jan 18, 2012
I am trying to add an excel document to a cad drawing using ole. I wish to make it transparent so that only the cells themselves are visible and not the white background and empty cells. (I hope that makes sense).
View 3 Replies
View Related
Nov 29, 2012
We have this problem at the moment with an Microsoft excel file that appears to have become stuck in the External references list, Ref C1-01-06. We would like to remove it if possible as it is now superseded (we can't change the file name unfortunately. What do we do if we can't reload, detach or bind? Its not referenced into anything else that is attached to the file, it is a direct attachment of the file that we are in.
View 3 Replies
View Related
Jan 26, 2013
What is the best way to Insert an Excel sheet into autocad?
View 4 Replies
View Related
Oct 13, 2012
I use an embedded excel file I a lot of my drawings. 90% of the time a double click opens excel for editing with no problem. But every so often I get a stubborn one that just will not open. It will select and the quick properties box will appear and then the properties box, but nor firing up of Excel. Usually if I am persistent I can get it to work, but I have one right now that is more stubborn than I am.
View 2 Replies
View Related
Sep 21, 2011
Seems like i export the data of thickness, diameter, lenght and mass to excel via dataextraction, but if i change something in the drawing, its not updated in the excel file..
I also wanted to export the data to an already existing part list template, but this seems impossible...
View 2 Replies
View Related
Oct 1, 2005
I'm having trouble changing a reference part back to normal. It's in a sub nested 2 levels. I earlier had it as a phantom but changed it easily to reference. Now I need it to be normal.
I've tried going into each level to change it. I cannot access it unless I change the BOM to read "Model Structure" since reference parts don't show up under BOM structure. When I click on Reference (it has a little X in it) it will seem like it's going to change but turns back to ref every time.
I went into the lowest sub & was able to change the part to Default through Properties but it just goes to reference again in the main assembly.
View 7 Replies
View Related
Apr 5, 2012
After Part is inserted into an assembly and after the Part is changed ( say the length from 16.25 to 17.75), How do I auto change the "Part Number" to match this new length in the parts list?
View 6 Replies
View Related
Aug 8, 2012
Is it possible to update an existing drawing to reference a new part or assembly file while maintaining associated views and possibly the annotation also?
I have tasks which require frequent subtle changes to assemblies. These assemblies will then be given a completely new file name, so it is no longer just a revision change but a new part altogether.
View 5 Replies
View Related
Mar 27, 2012
I have often right clicked a part in the browser of an assembly and edited its properties. This may include stock number, material and adaptability.
Drawings of these assemblies seem to update accordingly. At least initially.
I have noticed often several sessions later, the same properties have defaulted to their original value.
And I came across the statement in the corrections attachment.
What does the highlighted sentence mean, exactly? And which properties respond to a change at the part level when edited in an assembly?
Using Inventor 2012 Windows 7 Dell Precision dual EH(quad core) @ 2.13 GHz 4 G Ram
View 3 Replies
View Related
Jan 26, 2011
Is it possible to change the derived part link to another part like you would replace a component in an assembly? My issue is that i created a part and used a derived part within. Well this part number changed and it just so happens that the derived part needs to change as well. I tried the design assistant, and changed the link there but it didnt seem to want to take. I tried renaming the derived part, and opening the file...i get the error but i still am unable to change the link that way either.
Autodesk Inventor 2011
View 9 Replies
View Related
Jan 11, 2013
I need to change my parts list style for all of my drawings from this point forward. For the life of me I can't figure out how to do this. I have my project set to read-write and I've tried this 10 ways til Sunday but it won't take. There are several things that I want to achieve but I'd be happy with just one of them for now. All I want to do is remove the ITEM column from my default parts list. After this I want to merge rows by part number, etc.
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
View 9 Replies
View Related
Feb 14, 2012
I'm trying to link excel to autocad for a time now.
and until now it didn't work for me.
Everytime it says "1 data link(s) do not allow their data to be written out."
thats when i try to write it to the excel file.
View 5 Replies
View Related
Jan 27, 2012
Using AutoCAD 2010, and I'm having problems printing with one dwg, that I've had to copy an Excel Spreadsheet into. The spreadsheet was created with Excel 2007, and has quite a bit of text in it, and I'm trying to print it on an E size sheet, to an HP Designjet 4000. AutoCAD hangs up each time I try to print this, and my computer gets a message indicating that I'm low on disk space, even tho I do have plenty of space. It's like Autocad is taking more resources than it normally should. How I can insert this spreadsheet into AutoCAD and be able to print it? I've inserted the spreadsheet in model space, and the titleblock/border is in paperspace. I've tried printing to pdf and exporting to other formats to see if that will work, but AutoCAD keeps hanging up. Any other AutoCAD dwg works fine to print to the printer. It's just this one file with a spreadsheet inserted into it.
View 5 Replies
View Related
Aug 20, 2010
I just installed Autocad 2011. I have Excel tables in one of my drawings that was in Autocad 2004.
However, with new 2011, I can not bring the OLE to Excel where I want to edit.
I got "OLE Failed to launch server app" error message.
I search around. It seems that I need to try the command "OLELINKS". But my OLELINKS under EDIT is DISABLED!
View 8 Replies
View Related
Dec 4, 2012
Everytime I open up a new drawing an error pops up that there is (2) Xref that cant load. It seems to be the same (2) Excel files I have to go to the Datalink Manager and delete them. Is there any way to get in the Datalink Manager without opening a drawing to unlink these?
View 3 Replies
View Related
