AutoCAD Inventor :: Edit Via Spreadsheet Not Working?
Aug 16, 2012
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.
View 9 Replies
ADVERTISEMENT
Jul 19, 2012
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 Replies
View Related
Dec 29, 2011
Recently 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
View 3 Replies
View Related
Jun 20, 2013
I am having a problem with editing in place in Inventor 2012. Some parts will edit in place and some won't. Attached are a couple of files I am using which has this problem. I need the other assemblies in place so that I can locate a hole inline with a threaded insert.
View 8 Replies
View Related
Nov 7, 2012
I'm having problems with the crop feature in an Inventor idw. Having cropped my view I then go into the browser to edit the crop (edit sketch), the lines on the crop window will not move and I am unable to edit the selection, why is this not working ? Occasionaly I can move / resize one or two of the crop boundry lines but never all of them.
Autodesk Inventor Professional 2013 SP2 64-Bit Edition
Windows 7 HP Z400, Intel Xeon W3550 3.07GHz
12.0GB RAM, ATI FirePro V4800 (FireGL)
View 3 Replies
View Related
Aug 9, 2012
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
View 4 Replies
View Related
Feb 15, 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.
View 1 Replies
View Related
Nov 21, 2012
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 Related
Feb 1, 2011
I 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.
View 6 Replies
View Related
Apr 17, 2013
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...
View 4 Replies
View Related
Nov 15, 2012
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.
View 3 Replies
View Related
Sep 13, 2013
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 Related
May 15, 2013
I have problem with Hole and Thread load menu input Thread.
i see only Loading thread data spredsheet .Please wait
win xp x32
inventor 2013
View 1 Replies
View Related
Dec 6, 2010
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.
View 3 Replies
View Related
Jun 19, 2013
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?
View 4 Replies
View Related
May 11, 2007
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 Related
Jun 7, 2012
I 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.
View 2 Replies
View Related
Jul 26, 2012
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
View 1 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
Sep 20, 2013
For 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?
View 1 Replies
View Related
Apr 30, 2013
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)
View 4 Replies
View Related
Apr 18, 2013
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()
View 3 Replies
View Related
Aug 7, 2013
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.
View 3 Replies
View Related
Apr 9, 2012
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.
View 1 Replies
View Related
Dec 16, 2011
When I double-click on a text item, AutoCAD used to go to text edit mode, without entering the TEDIT command. This quit working - now I have to enter TEDIT.
Also, when I select items and hit the Delete key, nothing happens. The selected items used to get deleted.
I tried going to the Windows Start menu and resetting all of the settings to the defaults - this didn't work.
I also tried re-installing AutoCAD from my original disk, and that didn't work either.
View 2 Replies
View Related
Jul 22, 2008
My double click edit function is not working even though...
DBLCLKEDIT is <ON>
PICKFIRST = <1>
and my noun/verb selection box is checked
View 9 Replies
View Related
Jul 31, 2012
I am running autocad 2012 and my block edit command is not working. im getting the following response:
View 2 Replies
View Related
Jun 24, 2013
I develop AutoCAD using .NET, I use the Edit and Continue feature in Visual Studio 2008 while debugging and testing what I wrote. I recently got a new machine and now my Edit and Continue doesn't seem to work anymore.
View 9 Replies
View Related
Sep 5, 2012
I was working on a drawing file when my ribbon went haywire. My layer drop down seems frozen so it only shows the current layer and the hatch edit ribbon does not function properly.
The issue with the layer drop down is if I select a line, fill, etc. on any layer the layer drop down on the home ribbon does not change to show the layer that item is on and if I select multiple items on different layers which usually causes the drop down to go blank it still shows the current layer. The object color, line thickness and linetype all change on the properties tab to show the properties of the selected item so the entire home ribbon is not frozen. If I scroll through the layer drop down and select a layer to move the selected item to a new layer AutoCAD responds *Invalid selection* Expects a point or Window/Last/Crossing/BOX/All/Fence . . .
The hatch edit ribbon is completely useless. The angle and scale boxes are greyed out and if I select any of the buttons (Set Origin, change hatch pattern, etc.) AutoCAD again responds with *Invalid selection* . . .
The only CUI shown is the ACAD.CUIX and I have done a Reset and Restore, changed the workspace, restarted AutoCAD and restarted my computer. What am I missing?
AutoCAD 2011with current patches
Windows XP, SP3
View 2 Replies
View Related
Apr 22, 2013
When using photoshop cs5, I am unable to use any tool properly when using the touch screen.
Using the touchscreen, I am able to select the tool and other buttons, but when i attempt to draw with the brush tool, dragging a stylus across the screen does not create a line, and only visual feedback is seen. Dots can be drawn, ad the only way a line can be created is to double-click and drag which does not always work and is irritating to use.
View 2 Replies
View Related
Mar 10, 2013
I have my LR4 settings correct, when I click edit in PSE10, PSE10 opens but no photo transfers over with it
View 2 Replies
View Related
