I try to edit the table of an iPart via a spreadsheet (EXCEL 2010) and it does not launch EXCEL. I saw other posts with changing the registery and I am not too confident on what to remove or even how to do it.
View 6 RepliesRecently upgraded to Windows 7 from XP and changed from a laptop to a desktop. With the laptop I used dual monitors; to date I haven't secured a second monitor from IT for true dual monitors.
Well I have some iParts that I've edited using excel and they have formulas that I can't edit using the standard iPart dialog, but when I click "Edit via Spreadsheet" the window opens off screen. The alt+Spacebar method doesn't work in Windows 7 and the Windows 7 method of shift+right-click isn't an option because Excel doesn't appear on the taskbar and selcting Inventor moves the Inventor window, not the instance of excel inside of inventor.
2013 Product Design Suite Ultimate
Windows 7 Sp1
Intel(R) Core (TM) i5-2400 @ 2.00GHz
6.00 GB of RAM
AMD Radeon HD 6570
The Edit via spreadsheet option does not work, it will not call up Excel, although it believes that it does. The computer is running Win7 Ultimate sp 1 64, Office Home and Business 2010 sp1 32, Inventor 2012 sp2. The software (windows, office) is up to date, I have done the registry edit that other sites have mentioned.
I will bring up an .ipt, right click on Table, click on Edit via spreadsheet. I will get a circle for a cursor for a moment as if it were processing, then nothing. I right click on it again, and just get the How To option, so it believes Excel is open when it is not.
I have been trying to create an ipart. Once the ipart is created i am un-able to edit the sketches of features with issues.
I need to modify a sketch and to create an alternate sketch (suppress/unsuppress) but get an error message when i try to edit the sketch.
Windows 7 64 bit
Inventor 2012 Professional
Dell T1600 CPU E31245 @ 3.30GHz
8 GB RAM
i am working on an ipart. I have a spreadsheet with all the data and used the first line to creat the first part.
no problem.
i can add the remaining information to the table from the spreadsheet.
When returning to the drawing environment i can select a few parts that work and there are many more with "issues". So i move the first offending part select it and try to edit it. ( i know what i have to do to the sketch if i could just get into it) Also i have suppressed a sketch and inserted a new slightly different version (the issue) but, after getting out, i am un-able to edit this new sketch either.
the message comes back and says i cannot edit this part, and then....
unable to prepare the part for edit, updating your part is required to all the edit, update now?
Windows 7 64 bit
Inventor 2012 Professional
Dell T1600 CPU E31245 @ 3.30GHz
8 GB RAM
I successfully created multiple hatch regions in a sketch on a section view in a drawing. I want to change or delete one of the hatch regions, but am unsuccessful. I clicked on Fill/Hatch Region and then selected the region that already has a hatch defined, but the dialog box does not show that these is a hatch defined.
If I click the hatch button it creates another hatch over the top of the current one and does not allow the current one to be deleted or changed. Of the four regions in my sketch, one works and the other three do not.
When I double click a part in an assembly it does not edit the part.
When I right click "edit" is greyed out.
How do I edit a part in an assembly.
I can not edit the M text & field text in title box.My system is Windows Xp Professional 2002, Inventor 11.
I tried to install Microsoft Hotfix KB918118 as I did before, but I coulden't. System massege show my system is newer than that, so I do not need it. Then I installed Hotfix for text problem caused by Microsoft Hotfix KB918118. I can edit M Text now, but still I could not edit Field Text.
I am not able to edit degrees of freedom (dof) after playing a simulation.
This is what I did:
Created a dynamic simulation and imposed motion on a prismatic joint.Edit dof and Input Grapher before playing the simulation.Play the simulation.After playing simulation for first time, dof and Input Grapher are dimmed (grayed out) and can not be edited.
Here are screen shots of the dimmed dof and Input Grapher:
I am using Inventor 2012. A simple example is attached.
I have just inherited a project where I have been asked to supply our purchaser with a list of non-stocked fixings.
OK so far, i hear you ponder, but the designer for reasons of speed (his words) didn't add the fixings to the assmbly!
Is there any way to list all tapped hole features to an excel spread sheet so that i could then just sort and count and then be able to hilite the specific parts in inventor to find the length?
The prospect of looking at each individual part for tapped holes fills me with dread (shudder).
HP z210 16Gb ATI FirePro5800
Autodesk Produst design Suite 2012
Trying to figure out the best method to insert an IDW into an Excel spreadsheet without sacrificing quality. I have tried several methods to go straight from Inventor(2012) to Excel(2010) using print PDF at press quality, export JPEG, and even the snipping tool as a last ditch effort all of which inevitably loose all line quality when inserted to Excel.
I have only had success bringing a PDF from Inventor into Adobe InDesign where I am able to mimic the design of my Excel spreadsheet and create an additional PDF to include with the Excel document. It seems like there would be an easier way for Inventor and Excel to work together without sacrificing quality or adding additional steps.
I am trying to export some data from my BOM. I require the part names, quantities and lengths. I have followed a previous topic in these discussions which is now closed. it seems simple to follow but requires me to click on the export BOM icon in the top left of the browser. In my instance this is greyed out. D
View 4 Replies View RelatedI would like to use a multi-value custom iProperty 'item_finish' in the part or assembly model to drive an iLogic rule.
'item_finish' would be 1-24 from the list.
The part file would have an embedded spreadsheet with column A corresponding to the 'item_finish'.
The spreadsheet would have column B containg long text descriptions of the finish process.
The ilogic rule must take the 'item_finish' number, find the corresponding row and then return the B column cell text to a user parameter 'defined_finish'.
The 'defined_finish' parameter can be called in a sketched symbol to describe the finish.
It appears this is all possible, but I cannot find enough information describing the snipped code requiremnets to accomplish the goal.
Im struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
I am working on a gearbox design that requires multiple iterations on the shaft dimensins and other parts, so linking the dimiensinos to a spreadsheet would make this easier. However, I'm using the design accelerator for the shaft and other components and I cannot find any information on how to connect the dimensions I enter in that design accelerator to a speadsheet.
I know how to link to a spreadsheet for a regular component, but haven't used that much.
Is there a way of inserting points from an excel spreadsheet that come into the part file already fixed, instead of manually selecting the points and selecting the fix constraint?
View 2 Replies View RelatedI have problem with Hole and Thread load menu input Thread.
i see only Loading thread data spredsheet .Please wait
win xp x32
inventor 2013
I already have a cut list template in Excel that calculates my stock material, volume, etc when I populate the appropriate fields. It is also connected to an access database that has various information that automatically generates the final price of my product based on various suppliers prices and data with whom I do business with and so on.
I would like to know if there was a way with iLogic to make Inventor populate specific cells with information found in the BOM such as: description; Qty and custom iProperties value like dimensions, etc?
The reason why I'm making a new topic out of this is that I have read previous post about the issue, but they were regarding "exporting the BOM to an excel". I, on the other hand, would like to populate an already existing spreadsheet with data from the BOM
After exploring the iLogic snippets, I've only found the "export" option. It referenced the API snippets, but with limited programming knowledge there is not much I can understand.
My question is regarding the proper workflow within Inventor. We are currently using 2013 Pro.
I am trying to develop an Assembly that will take linked excel values and have the assembly repond to the user's input. This spreadsheet is to be general in form and is to be re-used for different projects. Right now, the excel values are linked to a master assembly file. This master file has a few iLogic rules to handle the user's input and to pass particular parameter values to the iAssemblies (read sub-assemblies). The iAssemblies are not that complex, but they are taking parameter values from the master, and using iLogic within the isub-assembly to choose the iAssembly member based on the parameter value.
Problem one:
There seems to be a problem with changing the iAssembly member. I have stabilized the iAssembly within the master Assembly. The isub-assembly does not update unless I open the isub-assembly file. In both the isub-assembly and the master assembly, I update at the end of each rule, and I trigger the rules after any parameter change.
The questions are:
Since there are 123 members (so far) in each of the 2 iAssemblies within the Master Assembly, do I really have to test the parameter 123 times to assign a particular iAssembly member? Or is there a more concise way to do this?
We are not using Vault yet, but with described workflow, will we have problems when we do migrate to a vault environment?
Is there a way that I can add helicoil tap info to the thread size spreadsheet so that I can use the data within the hole command and place helicoil-tapped holes into my models? I need some way to automatically flow the helicoil tap info into the drawing via a hole note.
View 8 Replies View RelatedI have several drawings with tables on them with broken links to spreadsheets which have been deleted.I can't edit the tables.
Is there a way of reusing the information in the table to recreate the spreadsheets or new tables.
My "parameter names" and "value" columns fill in under the Inventor Parameter chart, but for some reason I can't get the comment section to fill in.
Inventor 2011
07 Excel
Inventor 2011
Intel Core 2 Duo 2.93GHz
8GB RAM
Windows 7 Pro
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 RelatedFor Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
I was trying to play around with the software to get to know it, and... well, I think I made something weird in it. Everything was flowing nicely when I was following the tutorial about Editing Objects: I created a box, I selected that edit poly option from the modify tab and I could edit vertices totally nicely.
But then, I really don't know what happened, but, I don't know exactly when, I suddenly could not move the vertices AT ALL. They are pretty visible, but when I select them, they turn red and the axis are not editable! I'm so confused! I can edit the axis very normally if I'm using an option like Select and Move but... With the edit poly thing I just cannot! I tried everything I thought of: Made a new box, restarted the program, restarted the PC! But NOTHING worked.
EDIT: It took me almost an hour to figure out I wasn’t selecting the Select and Move tool!
I have some code (below) that will open my embedded excel spread sheet and it works great. Now I need the code to save and close the excel file after it’s been open.The embedded excel spreadsheet pushes some stuff the model and does a couple other thing. So all I really need is for the excel file to open, save, and close when the rule is run.Imports Inventor.
OLEDocumentTypeEnumExcelApp = CreateObject("Excel.Application")Dim ExcelFile As ReferencedOLEFileDescriptorExcelFile
=hisDoc.Document.ReferencedOLEFileDescriptors.Item(1)ExcelFile.Activate(kEditOpenOLEVerb, ExcelApp)
I have made this rule, that should fill out a cell in a spreadsheet with a text from IProperties.. but it seem to work only the first time. 2nd time i run it, nothing happends... not even the msgbox at the end...?!
GoExcel.Open("I:TEGNINGSNUMRE SKEMAERStandard nummer udtagning-test.xlsx", "80000")'Get new partnumber from Excel'Find next empty row in Column BFor RowPN = 2 To 1000RowPN = RowPN + 1If GoExcel.CellValue("B" & RowPN) = 1 Then'Insert title from open DocumentGoExcel.CellValue("C" & RowPN) = iProperties.Value("Summary", "Title")End IfNextGoExcel.Save()
I have a problem with using the excel spreadsheet to hold my parameters and then making them auto update in the model.
I have the excel 2003 spreadsheet saved in the same folder in the projects directory as the model. When I create the spreadsheet and enter the parameters and values etc I save and close the file.
When I am in inventor 2013 64 bit with SP1 installed, I open the model and can link the spreadsheet to the model and the model reflects the values in the spreadsheet. I also click update on the parameters dialog box.
I then open the spreadsheet and make some changes to the values, save the file and even go to the extreme of closing the file. When I go back into Inventor it recognises there has been some changes in the underlying spreadsheet. The update button is active in the tool bar. However trying to update the models by what ever means does not update the model parameters to those in the spreadsheet. Even closing the model and reopening it does not make a difference.
The only way I can get this to work is disconnecting the file and then reconnecting the file through the links option in the parameters dialog box. Then the model reflects the correct values and updates the model accordingly.
My concern is there is quite a bit of stuff on the net about 2013 not working with 2014 inventor anyway.
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.
How do I change the BOM structure of iParts from Normal to Purchased? The BOM editor in the assemblies that use the iParts have the iParts as read only. I can't find a way to change them to purchased from inside the iPart either.
View 3 Replies View RelatedIs there a way to add an iPart column to the iPartTableColumns collection? I'm using Inventor 2009.
View 5 Replies View Related