use excel formulas through VBA in CATIA -
i need in using catia correctly.
i'm tasked creating "support" part mould capscrew must inserted (regardless of length) maximum of 15mm. length of inserted capscrew depends on plate located above support part. in excel have created several formulas determine capscrew must used not know how use excel formulas in vba. there way use excel formulas or spreadsheets in vba?
'declaration of x "height of plate 9" dim x integer x = length1.value 'declaration of y result optimal length of capscrew used dim y integer y = 0 'formula length of capscrew used if (designtable1.configuration <= 15) = true y = x - 10 - 1 + 15 designtable2.configuration = y else y = x - 12 - 1 + 15 designtable2.configuration = y end if
try:
application.worksheetfunction.yourfunction(yourarguments)
there's better solution using worksheet functions in vba, though.
Comments
Post a Comment