Forum FlexPro – Discuss your topic!

Objects in a FlexPro data

Accueil > Community > Automation and VBA > Objects in a FlexPro data

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #12404
    David CHATELDavid CHATEL
    Participant

    Hello,
    I try with VBA to make a list of all the objects that are contained in a FlexPro data. I have already tip the following code, but it doesn’t works, it say that fpObjects a wrong parameter is. Can somedoby help me? Is there a possibility to do this? Thank you for your answer!

    ————————————————
    Sub LookForObjects()
    Dim appFlex As FlexPro.Application
    Dim dbFlex As FlexPro.Database
    Dim fpObjs As fpobjects
    Dim fpObj As fpObject

    Set appFlex = New FlexPro.Application
    Set dbFlex = appFlex.Databases.Open(“Path”)

    ‘this fonction doesn’t work
    Set fpObjs = dbFlex.RootFolder.Objects

    For Each fpObj In fpObjs
    Debug.Print fpObj.Name
    Next

    appFlex.Quit fpDoNotSaveChanges
    End Sub

    #8087
    David CHATELDavid CHATEL
    Participant

    Hello,
    I try with VBA to make a list of all the objects that are contained in a FlexPro data. I have already tip the following code, but it doesn’t works, it say that fpObjects a wrong parameter is. Can somedoby help me? Is there a possibility to do this? Thank you for your answer!

    ————————————————
    Sub LookForObjects()
    Dim appFlex As FlexPro.Application
    Dim dbFlex As FlexPro.Database
    Dim fpObjs As fpobjects
    Dim fpObj As fpObject

    Set appFlex = New FlexPro.Application
    Set dbFlex = appFlex.Databases.Open(“Path”)

    ‘this fonction doesn’t work
    Set fpObjs = dbFlex.RootFolder.Objects

    For Each fpObj In fpObjs
    Debug.Print fpObj.Name
    Next

    appFlex.Quit fpDoNotSaveChanges
    End Sub

    #8651
    Bernhard KantzBernhard Kantz
    Participant

    This code should work. Unfortunately, we cannot reproduce your problem.
    Please register FlexPro again in the command line:
    flexpro.exe /regserver
    If this step doesn’t help update all your Microsoft Office products and reinstall FlexPro.

    support@weisang.com

    #8652
    David CHATELDavid CHATEL
    Participant

    Thank you for your answer! I want to precise few things.
    I use this code with VBA Access and I am working with the standard version of FlexPro.

    With a another function, I can point of some objects (datasets, formulas, diagrams…) if I have before specified the type of this object.
    I cann’t manage to point an object if I don’t specify the type.
    Another element caught my attention. Then I write “Dim fpObjs as FlexPro.fpObjects”, I see that “fpObjects” is written with a capital on the O (in the selectionlist). See on the code, “fpobjects” is written whitout a capital. It that normal? Do I have to link another dll to get this function? Thank you for your help!

    #8653
    Bernhard KantzBernhard Kantz
    Participant

    VBA is generally not case sensitive, although it will transform keywords into a standard case configuration and force the case of variable names to conform to the case of the entry within the symbol table entry.
    If you use FlexPro7 your code should work.
    If you use FlexPro6 please try the code:

    
    Set fpObjs = dbFlex.RootFolder.Objects(".*")
    

    Support@weisang.com

    #8654
    David CHATELDavid CHATEL
    Participant

    I use FlexPro 6 and your last tip works!
    Thank you!

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.