String as a folder name

[jasmina.zlender@erl16.siemens.de]

There is a string in FlexPro formula. How can I ask if there is a folder that has this string as name?In VBA I use is Nothing operator in such cases.

[jasmina.zlender@erl16.siemens.de]

There is a string in FlexPro formula. How can I ask if there is a folder that has this string as name?In VBA I use is Nothing operator in such cases.

[Bernhard Kantz]

A possible solution could be the following: Create a new formula, rename it to IsFolder and paste the following text into the formula editor:

arguments strFolder
dim Err

try
	$strFolder : ".FLD"$.Name
catch Err
	return FALSE
End

return TRUE

Then you could call this helper formula like this:

	If IsFolder("Folder") Then ...
	If IsFolder("AFolderAnotherFolder") Then ...

The formula IsFolder tries to convert the object name into a reference to the object. If the object exists this is possible and accessing the Name property of the folder is a valid operation. Otherwise an error will occur which will be catched by the catch statement. The variable Err contains the error message as a string, but we do not need it here.

Support
support@weisang.com

[Author]

Posts