Message 1 of 3
iLogic: Shared Function
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi All,
I have made a function (SteelProfile( PartName, Profile)) which works fine inside the rule, but if I want to call to this function in other rules it doesn't work. My question is how a share this function so that each rule can call it?
My function:
Function SteelProfile(PartName, Profile) 'Sub function to get dimensions from excel ExcelFile = "C:\Users\...\SteelProfilesTable.xlsx" i = GoExcel.FindRow(ExcelFile, "Sheet1", "Name", "=", Profile) Parameter(PartName, "Parameter_B") = GoExcel.CurrentRowValue("b") Parameter(PartName, "Parameter_H") = GoExcel.CurrentRowValue("h") End Function
Main function and calling function
Sub Main()
'Roof Beams SteelProfile("RoofBeam", RoofBeam_profile) 'Calls the function with values
End Sub
-Leevi