I have an assembly that I have created a sketch on and applied some dimensions. I would like to send those properties to an excel file that can then be inserted into an idw. What is the best way to get the parameter values into an excel file that would update as the model changes? I found were more focused on changing the model with the excel sheet which is not what I'm trying to do. I did try them however, but whether I clicked link or embed nothing appeared in the excel file at all.
in inventor 2009: i linked parameter of 3D design from excel file. If i change the value on excel file --> dimension of 3D design will change. It work fine.
So, in inventor 2011, i can not do it: when change the value on excel file, 3D model does not change dimension.
I have a Multi-Value Parameter "MV" that I want to populate using a Named Range from an Excel file that is already populating other parameters for the same file.
I currently have the file working by populating "MV" by using the snippet from iLogic below...
The reason I don't like this method is because if ever that range changes... all the iLogic code will have to be updated as well. How to set a Multi-Value Parameter using a Named Range from an Excel file? I assumed the below snippet would work but I am receiving
"Array was not a one-dimensional array." as an error.
I have a MultiValue Parameter that I want to populate using a named range from an embedded excel spreadsheet. I would like an iLogic solution if possible because I need other people to be able to understand the code without too much difficulty.
One of the sample snippets given allows access but not if the excel file is embedded.
'GoExcel.NamedRangeValue("Part_Width") The code below works but not when using a named range. ' Load bearing housing typesMultiValue.List("parameter1") = GoExcel.CellValues("A1","A20") Is there something I'm missing? I was hoping to use something like below ' Populate MultiValue Parameter from excelMultiValue.List("parameter1") = GoExcel.CellValues("3rd Party:Embedding 4", "Sheet", "myNamedRange")
I have a set of sheet metal parts modeled in inventor that are produced in a wide range of sizes and several different sheet metal types.
The dimensions (length, width, flange size, etc) are driven from a spreadsheet. I would like to be able to have the user update the K Factor from the same spreadsheet by selecting a sheet metal type.
The sheet metal type and K factor are not listed in the parameters list with the other model dimensional data, so I'm not sure how to proceed.
I have user parameters that are no longer needed and are not being used anywhere. They each takes 4-5 seconds to delete, prior to 2012 this would happen instantly.
I got a deadline for my project, but I got a big problem:
"I cannot set the "parameter" for the End Value in Parameter Animate dialog"
For easy understand, let's see a example:
1. I got a part which has two parameters named: "A" and "MaxA" 2. I animate Favorited parameter A. 3. The End Value is MaxA_ (Everything is ok) 4. I finish Studio environment, then I change parameter MaxA_ from 200 mm to 400 mm 5. I turn back to Studio environment, the End Value now is "200 mm" (I want this will be MaxA_, so I can animate the flexible parameter).
show me how to keep the end value will be "MaxA_" after I change parameter?
Recently I have been trying to build table driven products and ipart tables, but when I copy a member to create a new part number, upon exiting the iassembly author I get the following message "excel installation is required for this operation. failed to launch excel". I have a fully functional version of 2010 Excel installed which has been used so it should be recognized in the windows registry. I am running Windows 8 and Autodesk Inventor 2014.
I am trying to publish to the CC a guide rail. The vendor of the rail gives me the option of entering the desired length of the rail. After that he gives me the option to choose between the length that I entered and a shorter and longer standard length witch can be delivered faster.
I want to do the same thing with my published part, but I cannot make a key parameter to change depending on the entered custom parameter. I want the user to make the next steps when inserting from the CC: 1- select the size of the rail; 2-select the type of the rail; 3- enter the desired length of the rail; 4- choose between the desired length and the 2 recommended lengths (I need these 3 lengths to be shown)
I have a beam that is simply supported and I am needing to do FEA analysis on it. Simply supported on the ends with a load in the middle. Hand calculations show deflection is 2.256in. FEA shows delfection as 1.247in.
I think the problem is the constraints that I have placed on it. I have one fixed constraints at each end. One of these needs to be fixed and the other needs to be able to move horizontally. How do I set this up to get the correct results?
I have downloaded Inventor 14, and the program appears to start up without problems. However, when i create a simple sketch, it first says "Choose a plane". In my textbook, it shows a picture of the three planes to choose from. However, my computer screen shows a blank gray screen. It appears some tool bars are missing as well.
However, if i click in the space where I imagine the axis should be, it takes me into sketch mode. Similarly, when I draw a line, the information bar reads like I am drawing a line, but no line shows up on the screen.
Is there a specific requirement on my computer I could be missing? I have downloaded Inventor twice, and both times had the same problem with the program. Perhaps a video card I need to have, or a certain RAM requirement?
Illustrator keeps freezing when applying an effect such as texture-grain to a simple gradient, or even rasterizing a simple black circle. My system is about a 6month old macbook pro with 16gb ram, i7 and AMD Radeon HD 6770M 1024 MB. What could be causing this? It wasn't like this when i first started using the laptop but has started to do it everytime i try and do any of those simple tasks recently.
I am creating a Carbon Fiber glider. I have drawn the entire file and assembled it in autodesk inventor. How can I take each individual part and create a mold that I can CNC out? I just need a mold CAD file and then can run it through mastercam to get the G&M Code.
i need to build about 8 versions of this simple box (see pic). base size, top size height... easy!
i have been using simple extruded boxes for most of my work to create the "path" of the frame, but with the tops being smaller than the base i need a new trick. also i know i will make more and more versions and would like to make new sizes a quick and simple job.
in Inventor 2010 we can save and load iLogic Paremeter with *.xml and just in my opinion we can control parameter using *xml or html. It's right or false?
I need to extrude a simple shape between two planes and then get the length as a parameter. Is there anyway of generating this? All I can find is a parameter for the angle of the extrusion.
I have generated frame that has 100 members in it. Is there a quicker way of changing G_L unit to a mm so that I don't have to go into all 100 parts to change the custom properties?
Also I do not need unit string to be appear in my BOM.
I set a dimension to a 2dline. The dimension is automatically added to Model Parameters. How can I find , by code, the line which length is driven by the parameter ? Or, starting from the line find the parameter which indicate its length ?
::GetDependents(), nor ::GetDrivenBy(), nor ::GetParent() gives me the answer.
I'm trying to get a parameter value from an Inventor .dwg file, but I keep getting an error saying the file is not found. I use this same code all over the place between different parts but its the first time I'm tried it using a dwg. Can you not access an Inventor .dwg parameters using iLogic .
Sometimes I change the dimensions of a material I use but then I have to open Iproperties and change the description by hand. This can create problems as you can understand especially when I forget to update the Iproperties.
Then I had the thought to automate it. Lets take a steel bar as example. I have thickness and width as parameter, both are exported and available under IProperties/Custom. But they show as 200 mm and 10 mm. I would like to loose the units. I tried also UL but then it reads 200 ul and 10 ul.
What I like to get are just the numbers, no units. I like to use it to create this "steel bar 200x10" where the 200 and the 10 are linked to the Parameter and will change when I change the dimensions av the steel bar.
Is there a way to use the filename to drive the parameters of the file?
Example: I have a cube that is called 4x4x4.ipt its dimensions d0,d1,d2 are 4,4,4 respectively. I want to rename it to 4x4x6.ipt and have the dimensions d0,d1,d2 resize to 4,4,6.
I'm trying to programmatically toggle a hole between tapped and simple. I found the Tapped property in the object browser but when I try to use it I get a "Method 'Tapped' of object 'HoleFeature' failed" error.
Public Sub setThd(tap As Boolean, doc As PartDocument)Dim hole As HoleFeatureDim holes As HoleFeaturesSet holes = doc.ComponentDefinition.Features.HoleFeaturesFor Each hole In holes If hole.HealthStatus <> kSuppressedHealth Then hole.tapped = tap End IfNextEnd Sub
I've got a custom VBA function that works perfectly when called from a parameter in my part.
However, when in the context of my assembly, there is no error, but the function no longer runs, and the parameter text is red.
Apparently, the function is no longer in context?
I've heard of external rules, but have never implemented one.
Is there a way to declare my function and keep it in context regardless?
Public Function BumpHeight(dblHeight As Double, dblMember As Double) As Double Dim X As Integer X = 2 If dblHeight > dblMember * 2 Then BumpHeight = dblHeight Else BumpHeight = dblMember * X End If BumpHeight = BumpHeight / 2.54 End Function Here is the Parameter:
VBA:BumpHeight(ValanceBackBumpoutHeight;ValanceMemberSize) * 1 in
Update: (problem better defined)
What seems to be happening is that once I insert the part into an assembly, it creates a new blank copy of the parts' modules in VBA and the functions no longer work.
If I go to the VBA editor,
There are now two copies of my part listed in the browser tree, but the new one is blank.
If I paste in my function to the new one, it will work until I return to the parent assembly.
Next time I come back to the part, it will have a new blank set of modules.
This appears to continue indefinitely...
see the attached screenshot.
At this point there are only 2 copies of the DocumentProject. The original still contains my functions, but the new one is blank.
I need these functions to work in order to build my model.
