Drop-down box

Nagaraj Arali

Forums

Hi everyone,
Can you please help me vb macro in idea
I have direct extraction equation below
@match(columnname,1000) and.columnname < 0
Where in scripting I need to change the column name by selecting drop-down and account numbers were changing Case by case so I need input different account numbers.
 
Please help me in this regard how to write macro for this.  
Thanks in advance 
Nagaraj Arali
 
 

Nagaraj Arali Wed, 07/19/2017 - 10:52

Hi Brian, 
Hope you are doing good.
please help me to merge two script in idea

Brian Element Thu, 07/20/2017 - 19:47

Hi Nagaraj,

Here you go.  I updated the Drop Down example to call two files that perform an extract based on extracting debits and one extracting credits.  All three files need to be in the macros.ILB folder to work properly.  You can see the code in the Drop Down example that sends over the filename, the match field, the amount field and the new filename.  There is a limit of only 4 arguments that can be sent doing this, if you need more you will need a work around.

So have a look and hopefully this helps you out.

Brian