Hi members of Idea scripting.com
I am a big fan of your work and thanks for this homepage; great inspiration and help.
I have a problem in scripting and maybe you can help: Currently we use IDEA 8.5 and will update to 10.3 in the end of 2019. The staff members of my company often use the right click in a database window for ‘Display All Records containing ...’, criteria and the equation editor. They filter out the data they need and want to finish the reports in MS Excel. Nearly every staff member uses different criteria ... therefor is no export with a predefined eqn = “ “ in the task=db.ExportDatabase possible.
The reduced Macro-Script is added below as txt. We bind the Macro to the ribbon for quick export with only one mouse-click.
The export to Excel for the whole current open mother database (before setting Criteria) works fine. – But I can’t find a solution to export the child database after the use of for ‘Display All Records containing’ or set criteria via ideascript.
My first question: The manual solution is “save as ...” and then export the separated child database as *.xlsx and open it in Excel by the Macro. Is there a snippet/script for “save as...” the current child database in for example: C:\temp (instead of export-task)?
My second question: Or is it possible to read out the actual set/defined criteria by ‘Display All Records containing ...’ by the user and define a variable for the equation in the export task for getting only the child database?
Maybe you can help? With best regards
Last seen: 3 months 1 week ago
Joined: 12/05/2017 - 13:35