I logic code in Inventor 2019 no longer working after update 2019.1

I logic code in Inventor 2019 no longer working after update 2019.1

Anonymous
Not applicable
257 Views
2 Replies
Message 1 of 3

I logic code in Inventor 2019 no longer working after update 2019.1

Anonymous
Not applicable

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

 

0 Likes
258 Views
2 Replies
Replies (2)
Message 2 of 3

Mark.Lancaster
Consultant
Consultant

@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.

0 Likes
Message 3 of 3

chandra.shekar.g
Autodesk Support
Autodesk Support

@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



0 Likes