Try like this
SET Str1 = 'abcdef';
SET Str2 = 'abcefg';
LET test = CommonStringLength((Str1), (Str2)); -- CommonStringLength is a macro function
function CommonStringLength(Str1, Str2)
strLength = Max(Len(Str1), Len(Str2))
For i=1 To strLength
If Mid(Str1,i,1) <> Mid(Str2,i,1) then
CommonStringLength = i-1
If i = strLength then CommonStringLength = strLength
Hope this helps you.
thanks for helping! But I think I have it now.
I didn't think of this because to my knowledge, whenever a variable contains alphanumeric digits, you needed that $-expansion - so I used it in the CALL_statement, too - but there it seems this is not allowed without regard of the variable_contents.
Now the variable is properly passed to the subroutine.
All should be well now - except in the longer run there won't be one workbook with six sheets to load, but six workbooks - the lists have to be exported manually because we will not get access to that tool for automatization, so I will try to keep that effort to the absolute minimum and work with whatever comes out of that tool.