Objects in a FlexPro data

[David CHATEL]

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

[David CHATEL]

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

[Bernhard Kantz]

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

[David CHATEL]

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!

[Bernhard Kantz]

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

[David CHATEL]

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

[Author]

Posts