Hi I need your help again.
I have discovered an error in my VBA sheet : My point is to import connection modifications from the excel sheet to Robot.
But for Fixed and pinned connection types, if I try to import 2 or more of connections defined in the structure (if not, it's work perfectly) the programm crashes.
for example, the code I use for pinnedconnections :
[start robot, etc]
For i = 1 To Cells(DernLigne, 1).Value
connect_number = Cells(6 + i, 1).Value
If RobApp.Project.Connections.Exist(connect_number) = 1 Then
Dim connect_info As IRJointConnectionInfo
Set connect_info = RobApp.Project.Connections.GetInfo(connect_number)
[...]
ElseIf Cells(6 + i, 2).Value = "pied de poteau articulé" Then
Dim pinned As IRJointPinnedColumnBase
Set pinned = RobApp.Project.Connections.Get(connect_number)
[...modifications...even if i put nothing it doesn't work...]
Call pinned.SetToRobot(connect_info) 'that this one which crashes'
Set pinned = Nothing
Set connect_info = Nothing
end if
[...end for, end robot, etc]
The program works perfectly with all bracket connections, with the same code even if I all are defined in the structure.
I don't understand why that crashes only with footconnections, and why in the second connection?
Please if you can help...
Sheet please and short explanation what to modify \ how to use it.
Don't look at the Material part, it's not coded yet
D'ont look at the Tekla part (sheet 2), don't imply Robot
sheet one, button "lancer la collecte" export the connections caracteric from robot to the sheet. that's work
sheet one, button "purge" just clear the sheet
sheet one, button "charger modifications" import the parameters from the sheet to robot. Works but :
- sometimes, not with diameters
- if 2 or more pinned/fixed connections defined from the structure are imported => crash
I would like you look at that (sub retourobot(), sheet 1)
thx Rafal
Not stared even to look at it yet.
Sorry.
I rememeber to check it.
Can't find what you're looking for? Ask the community or share your knowledge.