- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I logic code in Inventor 2019 no longer working after update 2019.1
I was using this code to export parameters to Excel and then repopulate multi value list back from the excel spread sheet, and after the update the code would no longer export anything, and the parameter which contained the multi value list changed back into a normal parameter without a multi value list and without all of the other variables in the list. Once i rolled back the update everything worked fine.
SyntaxEditor Code Snippet
Dim Counter As Integer = 0 Dim TheValue As String = "" GoExcel.Open(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1") GoExcel.FindRow(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1", "COMPLETE_SPEC_CODE", "=", COMPLETE_SPEC_CODE) COMPLETE_SPEC_CODE_LIST = COMPLETE_SPEC_CODE If GoExcel.CurrentRowValue ("COMPLETE_SPEC_CODE") = COMPLETE_SPEC_CODE Then MessageBox.Show("This spec code is already in use", "Spec code conflict") Else While Counter <> 10000 Counter = Counter + 1 If GoExcel.CellValue(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1", "A" & Counter) = "" Then GoExcel.CellValue(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1", "A" & Counter) = COMPLETE_SPEC_CODE GoExcel.CellValue(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1", "B" & Counter) = KVA GoExcel.CellValue(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1", "C" & Counter) = LV GoExcel.CellValue(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1", "D" & Counter) = HV_KV_BIL GoExcel.CellValue(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1", "CG" & Counter) = DOUBLE_CLF_FUSE Counter = 10000 End If End While End If MultiValue.List("COMPLETE_SPEC_CODE_LIST") = GoExcel.CellValues(ThisDoc.Path & "\MINI OUTLINE ASSY PARAMETERS.xlsx", "Sheet1", "A2", "A10000") GoExcel.Save GoExcel.Close
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
@Anonymous
This is not installation and licensing issue and you should be posting in the Inventor customization forum. This forum will not get into issues within the actual program such as ilogic. I will have the moderator relocate it there to better suit your needs.
Mark Lancaster
& Autodesk Services MarketPlace Provider
Autodesk Inventor Certified Professional & not an Autodesk Employee
Likes is much appreciated if the information I have shared is helpful to you and/or others
Did this resolve your issue? Please accept it "As a Solution" so others may benefit from it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
@Anonymous,
Can you please provide reproducible steps and part file with excel to investigate?
Please make sure that files are non confidential.
Thanks and regards,
CHANDRA SHEKAR G
Developer Advocate
Autodesk Developer Network
