I have a database with a number of imported Excel workbooks. Now I want to search the database eg for a Text occuring in a cell in one of the workbooks eg Lipex.
I tried with the find function when the databse is activated but could not get it to work.
It’s not possibe to search in several Excel workbooks. You can only search for FlexPro objects (data sets, formulas, …) in the folder or in the database.
In FlexPro Professional it should be possible to create a macro which searches in embedded worksheets using the object model of Excel.
I have a database with a number of imported Excel workbooks. Now I want to search the database eg for a Text occuring in a cell in one of the workbooks eg Lipex.
I tried with the find function when the databse is activated but could not get it to work.
.