Worksheet functions in VBA

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Worksheet functions in VBA

    Hi everybody,

    I have a question about the worksheet functions in VBA: I would like to get the number of child of a parent in a specific dimension in one of my variable. I wrote this code:

    Source Code

    1. Sub ListChildren()
    2. ReturnCode = Application.Run("PALO.ENABLE_LOOP", True)
    3. MyNumberofElements = Application.Run("PALO.EFIRST", "localhost/PILOR", "Entity")
    4. Debug.Print MyNumberofElements
    5. ReturnCode = Application.Run("PALO.ENABLE_LOOP", False)
    6. End Sub

    If I execute this code, the debug.print command returns "Error 2036"

    Is it possible to get this information into a single variable ?

    Thanks in advance for your kind help.


    Post hoc, non est propter hoc